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
> Would it make sense to mention this in docs of VACUUM FULL? Either at
> or at
Yeah, maybe. Want to suggest a wording?
In response to
pgsql-hackers by date
|Next:||From: Gurjeet Singh||Date: 2008-09-30 11:47:53|
|Subject: Re: Index size increases after VACUUM FULL|
|Previous:||From: Heikki Linnakangas||Date: 2008-09-30 11:02:51|
|Subject: FSM rewrite committed, loose ends|