Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5599: Vacuum fails due to index corruption issues - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5599: Vacuum fails due to index corruption issues
Date
Msg-id 1281029938-sup-3072@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #5599: Vacuum fails due to index corruption issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5599: Vacuum fails due to index corruption issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Excerpts from Tom Lane's message of jue ago 05 13:19:41 -0400 2010:

> In any case, the removal of VACUUM FULL didn't completely disable
> shrinking of btree indexes did it?  I don't recall having removed
> that.

I see no call to RelationTruncate in the btvacuumscan code, but then it
was only called in vacuum full before.  I'm not sure how it worked
previously with only lazy vacuum.  Did we simply leave the pages as free
for a later extension?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: string_agg delimiter having no effect with order by
Next
From: Tom Lane
Date:
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues