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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron St-Pierre | 2007-10-23 16:43:08 | Re: 12 hour table vacuums |
Previous Message | Gregory Stark | 2007-10-23 16:38:29 | Re: 12 hour table vacuums |