Re: vacuum full table - internals in 8.3

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Kieren Scott <kierenscott(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum full table - internals in 8.3
Date: 2010-10-06 04:41:51
Message-ID: 4CABFE0F.5040500@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kieren Scott wrote:
> I'm trying to understand what is going on internally when doing a
> VACUUM FULL on a table in 8.3.

The info you've gotten from Kevin is all correct, but you may find some
of the additional trivia in this area collected at
http://wiki.postgresql.org/wiki/VACUUM_FULL interesting as well.

--
Greg Smith, 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lukasz Brodziak 2010-10-06 06:45:25 Can't access tables.
Previous Message Vishnu S. 2010-10-06 03:40:24 Re: [GENERAL] Data Not replicating