On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke <jens@wilke.org> wrote:
On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
> > IIRC "vacuum full" mode rewrites the indexes as well. > > Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
Don't be confused with the "vacuum full" term. This has nothing to do with the postgresql "vacuum full" command. Both pg_reorg's "vacuum full" and "cluster" mode do the pretty same thing. They rewrite the table and all their indexes. They use triggers to update the new table during the reorganisation. The only difference is that "cluster" does an additional order by. Both of them lock the original table at the end of the reorganisation just for the switch. If the lock is not granted within -T seconds, the backends holding locks are canceled.
If you run out of diskspace, it's possible to reorg table by table. And yes, pg_reorg does only work with tables with a primary key. This will change in future releases, IIRC
How does it do with tables that have huge amounts (50 - 100 GB ) of TOASTed data?