Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum full table - internals in 8.3 - Mailing list pgsql-admin

From Greg Smith
Subject Re: vacuum full table - internals in 8.3
Date
Msg-id 4CABFE0F.5040500@2ndquadrant.com
Whole thread Raw
In response to vacuum full table - internals in 8.3  (Kieren Scott <kierenscott@hotmail.com>)
List pgsql-admin
Tree view
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@2ndQuadrant.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

pgsql-admin by date:

Previous
From: hsienwen chu
Date:
Subject: Question about the IO on full table scan operation
Next
From: "Vishnu S."
Date:
Subject: Re: [GENERAL] Data Not replicating