Re: 12 hour table vacuums - Mailing list pgsql-performance

From Bill Moran
Subject Re: 12 hour table vacuums
Date
Msg-id 20071023124148.52d33ee8.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: 12 hour table vacuums  (Ron St-Pierre <ron.pgsql@shaw.ca>)
List pgsql-performance
In response to Ron St-Pierre <ron.pgsql@shaw.ca>:

> Bill Moran wrote:
> > In response to Ron St-Pierre <ron.pgsql@shaw.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@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: 12 hour table vacuums
Next
From: Ron St-Pierre
Date:
Subject: Re: 12 hour table vacuums