Skip site navigation (1) Skip section navigation (2)

Re: VACUUMs take twice as long across all nodes

From: Gavin Hamill <gdh(at)laterooms(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUMs take twice as long across all nodes
Date: 2006-10-26 20:35:56
Message-ID: 20061026213556.174bd7b5.gdh@laterooms.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 :)

Cheers,
Gavin.

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-10-26 21:53:10
Subject: Re: query slows down drastically with increased number of fields
Previous:From: Jim C. NasbyDate: 2006-10-26 19:19:18
Subject: Re: Stored procedure slower than sql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group