From: Rod Taylor <rbt@rbt.ca>
To: Clarence Gardner <clarence@silcom.com>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: Oleg Lebedev <oleg.lebedev@waterford.org>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: slow query
Date: 24 Feb 2003 13:39:12 -0500
Message-ID: <1046111952.632.34.camel@jester> (raw)
In-Reply-To: <Pine.LNX.4.44.0302240925360.25665-100000@liberty.sba2.netlojix.net>
References: <Pine.LNX.4.44.0302240925360.25665-100000@liberty.sba2.netlojix.net>
On Mon, 2003-02-24 at 12:27, Clarence Gardner wrote:
> On 24 Feb 2003, Robert Treat wrote:
>
> >
> > If your seeing wildly dramatic improvments from vacuum full, you might
> > want to look into running regular vacuums more often (especially for
> > high turnover tables), increase your max_fsm_relations to 1000, and
> > increasing your max_fsm_pages.
>
> I don't know about the settings you mention, but a frequent vacuum
> does not at all obviate a vacuum full. My database is vacuumed every
> night, but a while ago I found that a vacuum full changed a simple
> single-table query from well over 30 seconds to one or two. We now
> do a vacuum full every night.
Sure is does. If your free-space-map (FSM) is up to date, tuples are
not appended to the end of the table, so table growth will not occur
(beyond a 'settling' point.
Unless you remove more data from the table than you ever expect to have
in the table again, this is enough. That said, the instant the FSM is
empty, you're table starts to grow again and a VACUUM FULL will be
required to re-shrink it.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
[application/pgp-signature] signature.asc (186B, ../1046111952.632.34.camel@jester/2-signature.asc)
download
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: rbt@rbt.ca, clarence@silcom.com, xzilla@users.sourceforge.net, oleg.lebedev@waterford.org, josh@agliodbs.com
Subject: Re: slow query
In-Reply-To: <1046111952.632.34.camel@jester>
* 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