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

Re: 12 hour table vacuums

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 12 hour table vacuums
Date: 2007-10-23 16:41:48
Message-ID: 20071023124148.52d33ee8.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-performance
In response to Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca>:

> Bill Moran wrote:
> > In response to Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca>:
> >
> >   
> >> We vacuum only a few of our tables nightly, this one is the last one 
> >> because it takes longer to run. I'll probably re-index it soon, but I 
> >> would appreciate any advice on how to speed up the vacuum process (and 
> >> the db in general).
> >>     
> >
> > I doubt anyone can provide meaningful advice without the output of
> > vacuum verbose.

Understood, however I may have spoken too soon.  It appears that Tom
found an obvious issue with your config that seems likely to be the
problem.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

pgsql-performance by date

Next:From: Ron St-PierreDate: 2007-10-23 16:43:08
Subject: Re: 12 hour table vacuums
Previous:From: Gregory StarkDate: 2007-10-23 16:38:29
Subject: Re: 12 hour table vacuums

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