I am running a daily pg_dump on PostgreSQL 9.3.14 database of approx. 50 GB of size:
pg_dump -Fc dbname > file
The problem I am having is that while
pg_dump runs, which takes several hours, all the other database connections are extremely slow.
Is there any way to make the
pg_dump consume less resources or is there a more proper way of creating periodic backups that doesn't slow down the db server so much?
E.g. would running pg_dump from a different server help the database I/O on its working server?