Re: VACUUM FULL for performance

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Bill Moran <wmoran(at)potentialtech(dot)com>, Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, AI Rumman <rummandba(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM FULL for performance
Date: 2010-10-07 13:53:13
Message-ID: 298310.22048.qm@web29013.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I also recommend reindexing any table that has been VACUUM FULLed.

Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table,
so I expect the indexes to be re-created anyway... so a reindexing would
be totally useless.

Am I wrong?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2010-10-07 14:06:53 Re: PostgreSQL 7.4.16 is creating strange files under /var/lib/pgsql
Previous Message Tatsuo Ishii 2010-10-07 13:50:56 Re: Tutorials on high availability Postgresql setup?