From: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | DB responce during DB dump |
Date: | 2006-01-25 12:01:34 |
Message-ID: | 20060125150134.55589806.eugrid@fpm.kubsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2006-01-25 12:44:45 | Re: DB responce during DB dump |
Previous Message | Alessandro Baretta | 2006-01-25 09:05:44 | Re: Inconsistant query plan |