Hi, everybody!
I experience problems with backing up one of my Postgresql 8.1.2 installations.
The problem is that when I do DB backup, all queries begin to run very slow =(
The database only grows in its size (~20Gb today), and the number of transactions increases every month.
A year ago such slow down was OK, but today it is unacceptable.
I found out that pg_dump dramatically increases hdd I/O and because of this most of all
queries begin to run slower. My application using this DB server is time-critical, so
any kind of slow down is critical.
I've written a perl script to limit pg_dump output bandwidth, a simple traffic shaper,
which runs as: pg_dumpall -c -U postgres | limit_bandwidth.pl | bzip2 > pgsql_dump.bz2
The limit_bandwidth.pl script limits pipe output at 4Mb/sec rate, which seems to be ok.
Is there any other solution to avoid this problem?
--
Evgeny Gridasov
Software Engineer
I-Free, Russia