Skip site navigation (1) Skip section navigation (2)

Re: Index size increases after VACUUM FULL

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index size increases after VACUUM FULL
Date: 2008-09-30 11:19:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Gurjeet Singh wrote:
> On Tue, Sep 30, 2008 at 3:09 PM, Heikki Linnakangas <
> heikki(dot)linnakangas(at)enterprisedb(dot)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
> or at

Yeah, maybe. Want to suggest a wording?

   Heikki Linnakangas

In response to


pgsql-hackers by date

Next:From: Gurjeet SinghDate: 2008-09-30 11:47:53
Subject: Re: Index size increases after VACUUM FULL
Previous:From: Heikki LinnakangasDate: 2008-09-30 11:02:51
Subject: FSM rewrite committed, loose ends

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group