Mark Mikulec wrote:
> The strange thing is that this started after my database grew by
> about 25% after a large influx of data due to user load
In addition to the issues already mentioned, there is the fact that
to maintain consistency an entire database must be dumped in a
single database tr
On 02/15/2011 10:41 AM, Mark Mikulec wrote:
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 execu
] pg_dumpall affecting performance
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
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.
Th
