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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
