Re: [GENERAL] Index vacuum improvements in 8.2

2007-01-09 Thread Alvaro Herrera
Joseph Shraibman wrote: > 8.0.x has the problem that VACUUM FULL on a table does not reclaim space > from the indexes, and I have to issue a separate REINDEX command. Has > this been fixed in later versions? No. -- Alvaro Herrerahttp://www.CommandPrompt.com/ Th

Re: [GENERAL] Index vacuum improvements in 8.2

2007-01-08 Thread Joseph Shraibman
8.0.x has the problem that VACUUM FULL on a table does not reclaim space from the indexes, and I have to issue a separate REINDEX command. Has this been fixed in later versions? ---(end of broadcast)--- TIP 5: don't forget to increase your free s

Re: [GENERAL] Index vacuum improvements in 8.2

2007-01-05 Thread Wes
>From 8.2 release notes: Speed up vacuuming of B-Tree indexes (Heikki Linnakangas, Tom) >From "2. Vacuum is now done in one phase, scanning the index in physical order. That significantly speeds up index vacuums of large inde

[GENERAL] Index vacuum improvements in 8.2

2006-12-29 Thread Wes
>From 8.2 release notes: Speed up vacuuming of B-Tree indexes (Heikki Linnakangas, Tom) >From "2. Vacuum is now done in one phase, scanning the index in physical order. That significantly speeds up index vacuums of large inde