Re: good old VACUUM FULL - Mailing list pgsql-performance

From Craig Ringer
Subject Re: good old VACUUM FULL
Date
Msg-id 4D95496E.1050407@postnewspapers.com.au
Whole thread Raw
In response to Re: good old VACUUM FULL  (Chris <dmagick@gmail.com>)
List pgsql-performance
On 23/03/2011 12:24 PM, Chris wrote:

> You'll need to reindex that table now - vacuum full can bloat your
> indexes which will affect your other queries.

It doesn't seem to matter much for a one-off. Index bloat problems have
mainly been encountered where people are running VACUUM FULL as part of
routine maintenance - for example, from a nightly cron job.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

pgsql-performance by date:

Previous
From: Joseph Shraibman
Date:
Subject: table contraints checks only happen in planner phase
Next
From: Greg Smith
Date:
Subject: Re: COPY with high # of clients, partitioned table locking issues?