Skip site navigation (1) Skip section navigation (2)

Re: Index bloat, reindex weekly, suggestions etc?

From: "Tory M Blue" <tmblue(at)gmail(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Date: 2008-10-17 17:48:07
Message-ID: 8a547c840810171048y27f1447ci2f125f19f1e0c5e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Oct 17, 2008 at 10:35 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> As already pointed out, that's a lot of free space.  You don't use
> VACUUM FULL on this database, do you?  That would keep the data
> relatively tight but seriously bloat indexes, which is consistent with
> your symptoms.  VACUUM FULL should not be used routinely, it is
> basically for recovery from serious heap bloat when you don't have
> space for another copy of the data, and it should usually be followed
> by a REINDEX to clean up the index bloat it causes.


Interesting, I do run:

 "# vacuum and analyze each db before dumping
psql $DB -c 'vacuum analyze verbose'""


every night before I dump, is that causing some issues that I'm not aware of?

Tory

In response to

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2008-10-17 17:53:58
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Previous:From: Kevin GrittnerDate: 2008-10-17 17:35:32
Subject: Re: Index bloat, reindex weekly, suggestions etc?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group