Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 995B42E2DC2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 11:46:29 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 37536-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 11:46:14 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id BFBC42E002E
	for <pgsql-performance@postgresql.org>;
	Wed,  5 Mar 2008 11:46:23 -0400 (AST)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Wed, 05 Mar 2008 09:46:22 -0600
Message-Id: <47CE6BDC.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Wed, 05 Mar 2008 09:46:05 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Steinar H. Gunderson" <sgunderson@bigfoot.com>,
	"SPMLINGAM" <spmlingam@gmail.com>
Cc: <pgsql-performance@postgresql.org>
Subject: Re: postgresql performance
References: <15847165.post@talk.nabble.com> <20080305103945.GA3673@uio.no>
In-Reply-To: <20080305103945.GA3673@uio.no>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/79
X-Sequence-Number: 29033

>>> On Wed, Mar 5, 2008 at  4:39 AM, in message <20080305103945.GA3673@uio.=
no>,
"Steinar H. Gunderson" <sgunderson@bigfoot.com> wrote:=20
=20
> it's pretty obvious that you
> haven't vacuumed in a very long time. Run VACUUM FULL on your tables
=20
If you use VACUUM FULL, you should probably throw in ANALYZE with
it, and REINDEX, too.  An alternative that is probably faster, but
which requires that you have enough free space for a temporary
additional copy of the data, is to CLUSTER the bloated tables,
which automatically takes care of the indexes, but requires a
subsequent ANALYZE.
=20
> regular (non-FULL) VACUUMs or enable autovacuum.
=20
Absolutely!
=20
-Kevin
=20