I was hoping use pg_dump and not to have to do a manual dump but if that
latest solution (moving rows >300mb elsewhere and dealing with them
later) does not work I'll try that.
Thanks everyone.
Merlin Moncure wrote:
On Fri, Dec 26, 2008 at 12:38 PM, Tom Lane wrote:
Ted Allen writes:
On Fri, 26 Dec 2008, Dmitry Koterov wrote:
checkpoint_timeout = 1min
Your system is having a checkpoint every minute. You can't do that and
expect the background writer to do anything useful. As shown in your
stats, all the dirty buffers are getting written out by those constant
checkpoin
