Re: [GENERAL] pg_dump slow on windows

2012-09-22 Thread Jasen Betts
On 2012-09-06, Kobus Wolvaardt wrote: > Something that is curios is that if a DB takes long, it really takes > horribly long like some kind of a lock is holding it. It would sit at a few > kb dump size for 20 minutes en then run a bit and get stuck again (as far > as we can tell), what we do know

Re: [GENERAL] pg_dump slow on windows

2012-09-06 Thread John R Pierce
On 09/06/12 1:34 PM, Kobus Wolvaardt wrote: Something that is curios is that if a DB takes long, it really takes horribly long like some kind of a lock is holding it. It would sit at a few kb dump size for 20 minutes en then run a bit and get stuck again (as far as we can tell), what we do kn

[GENERAL] pg_dump slow on windows

2012-09-06 Thread Kobus Wolvaardt
Hi, I hope this is the right list. I have read through a few pg_dump slow posts but none of them seem to apply to our case. We have a nice big server running windows server 2008 and postgres 8.4. The machine does nothing else and every so often running the nightly backup take 10 to 12 hours to com