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

help / color / mirror / Atom feed

From: Jim C. Nasby <jnasby@pervasive.com>
To: Bill Moran <wmoran@collaborativefusion.com>
Cc: Bealach-na Bo <bealach_na_bo@hotmail.com>
Cc: ahodgson@simkin.ca
Cc: pgsql-performance@postgresql.org
Subject: Re: Why so slow?
Date: Tue, 2 May 2006 15:17:41 -0500
Message-ID: <20060502201740.GB97354@pervasive.com> (raw)
In-Reply-To: <20060430100346.20f010a9.wmoran@collaborativefusion.com>
References: <200604281043.16083@hal.medialogik.com>
	<BAY101-F38A0FADC87E67C062FE5E1ADB00@phx.gbl>
	<20060430100346.20f010a9.wmoran@collaborativefusion.com>

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.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

view thread (26+ messages)  latest in thread

Message-ID: <20060502201740.GB97354@pervasive.com>
Permalink:  ../20060502201740.GB97354@pervasive.com/
Also on:    postgresql.org/message-id/20060502201740.GB97354@pervasive.com

copy link · copy postgr.es

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