Gurjeet Singh wrote:
> On Tue, Sep 30, 2008 at 3:09 PM, Heikki Linnakangas <
> heikki.linnakangas@enterprisedb.com> wrote:
>> That's normal. VACUUM FULL creates new index pointers for the tuples it
>> moves, which can lead to a bigger index. If it bothers, REINDEX will pack
>> the indexes tighter again.
>
>
> That explains it... and yes, REINDEX did bring the index size back to
> normal.
>
> Would it make sense to mention this in docs of VACUUM FULL? Either at
>
> http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html
>
> or at
>
> http://www.postgresql.org/docs/8.3/static/sql-vacuum.html
Yeah, maybe. Want to suggest a wording?
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com