From: Bill Moran <wmoran@collaborativefusion.com>
To: Ron St-Pierre <ron.pgsql@shaw.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: 12 hour table vacuums
Date: Tue, 23 Oct 2007 12:41:48 -0400
Message-ID: <20071023124148.52d33ee8.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <471E224C.5060607@shaw.ca>
References: <471E18ED.3090704@shaw.ca>
<20071023120750.ad8a1f54.wmoran@collaborativefusion.com>
<471E224C.5060607@shaw.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, ron.pgsql@shaw.ca
Subject: Re: 12 hour table vacuums
In-Reply-To: <20071023124148.52d33ee8.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox