From: Mark Mikulec <mark@anticentertainment.com>
To: pgsql-performance@postgresql.org
Subject: pg_dumpall affecting performance
Date: Tue, 15 Feb 2011 13:41:04 -0500
Message-ID: <a483a34e4c34f31e44ee156f79c0fc71@anticentertainment.com> (raw)
Hello,
I was under the impression that pg_dumpall didn't affect database
performance when dumping while the db is live. However I have evidence to
the contrary now - queries that are run during the pg_dumpall time take 10
to a 100 times longer to execute than normal while pg_dumpall is running.
The strange thing is that this started after my database grew by about 25%
after a large influx of data due to user load. I'm wonder if there is a
tipping
point or a config setting I need to change now that the db is larger that
is
causing all this to happen.
Thanks,
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@anticentertainment.com
Subject: Re: pg_dumpall affecting performance
In-Reply-To: <a483a34e4c34f31e44ee156f79c0fc71@anticentertainment.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox