pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bill Moran <wmoran@collaborativefusion.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: bealach_na_bo@hotmail.com
Cc: ahodgson@simkin.ca
Cc: pgsql-performance@postgresql.org
Subject: Re: Why so slow?
Date: Tue, 2 May 2006 19:28:34 -0400
Message-ID: <20060502192834.6c8e9131.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <20060502201740.GB97354@pervasive.com>
References: <200604281043.16083@hal.medialogik.com>
	<BAY101-F38A0FADC87E67C062FE5E1ADB00@phx.gbl>
	<20060430100346.20f010a9.wmoran@collaborativefusion.com>
	<20060502201740.GB97354@pervasive.com>

"Jim C. Nasby" <jnasby@pervasive.com> wrote:

> On Sun, Apr 30, 2006 at 10:03:46AM -0400, Bill Moran wrote:
> > At this point, it seems like you need to do 2 things:
> > 1) Schedule lazy vacuum to run, or configure autovacuum.
> > 2) Schedule some downtime to run "vacuum full" to recover some disk space.
> > 
> > #2 only needs done once to get you back on track, assuming that #1 is
> > done properly.
> 
> You'll also want to reindex since vacuum full won't clean the indexes
> up. You might also want to read
> http://www.pervasivepostgres.com/instantkb13/article.aspx?id=10087 and
> http://www.pervasivepostgres.com/instantkb13/article.aspx?id=10116.

Reindexing is in a different class than vacuuming.  Neglecting to vacuum
creates a problem that gets worse and worse as time goes on.  Neglecting
to reindex does not create an infinately growing problem, since empty
index pages are recycled automatically.  It's also conceivable that some
usage patterns don't need to reindex at all.

http://www.postgresql.org/docs/8.1/interactive/routine-reindex.html

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com



view thread (26+ messages)  latest in thread

Message-ID: <20060502192834.6c8e9131.wmoran@collaborativefusion.com>
Permalink:  ../20060502192834.6c8e9131.wmoran@collaborativefusion.com/
Also on:    postgresql.org/message-id/20060502192834.6c8e9131.wmoran@collaborativefusion.com

 · 

reply
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, jnasby@pervasive.com, bealach_na_bo@hotmail.com, ahodgson@simkin.ca
  Subject: Re: Why so slow?
  In-Reply-To: <20060502192834.6c8e9131.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