Postgres Pro
Downloads
Home   >   mailing lists

Re: Any experience using "shake" defragmenter? - Mailing list pgsql-performance

From Robert Haas
Subject Re: Any experience using "shake" defragmenter?
Date
Msg-id AANLkTikJeisVNDvqdNitvA5L+sps8ateO=sj6BGhX30C@mail.gmail.com
Whole thread Raw
In response to Re: Any experience using "shake" defragmenter?  (Grant Johnson <grant@amadensor.com>)
List pgsql-performance
Tree view 
On Tue, Feb 1, 2011 at 3:31 PM, Grant Johnson <grant@amadensor.com> wrote:
> Does vacuum full rewrite the whole table, or only the blocks with free
> space?

The whole table.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Grant Johnson
Date:
Subject: Re: Any experience using "shake" defragmenter?
Next
From: Mark Kirkwood
Date:
Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages?