On Thu, 26 Oct 2006 14:17:29 -0500
"Jim C. Nasby" <jim(at)nasby(dot)net> wrote:
> Are you sure that there's nothing else happening on the machine that
> could affect the vacuum times? Like, say a backup? Or perhaps updates
> coming in from Slony that didn't used to be there?
I'm absolutely certain. The backups run from only one slave, given that
it is a full copy of node 1. Our overnight traffic has not increased
any, and the nightly backups show that the overall size of the DB has
not increased more than usual growth.
Plus, I have fairly verbose logging, and it's not showing anything out
of the ordinary.
Like I said, it's one of those awful hypothesis/hand-waving problems :)
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-10-26 21:53:10|
|Subject: Re: query slows down drastically with increased number of fields |
|Previous:||From: Jim C. Nasby||Date: 2006-10-26 19:19:18|
|Subject: Re: Stored procedure slower than sql?|