What is better to take, a dedicated database or connect your own to a vps?

Question

PostgreSQL

For example, there is a vps on it has a backend, and is it better to use a dedicated database on heroku, elephantsql, etc., or install postgresql on the vps and connect to the database via localhost? Is there any difference?

Answer 1

Is there any difference?

Undoubtedly. The local database is much faster in working on large volumes.

Answer 2

for speed the local DBMS is better
for reliability - by the separate machine.