Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Does VACUUM reorder tables on clustered indices
- From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
- Subject: Re: Does VACUUM reorder tables on clustered indices
- Date: Thu, 29 Dec 2005 22:25:14 -0500 (EST)
Tom Lane wrote: > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes: > > Tom, has this bug been addressed or documented? > > No. Please add a TODO: > > * Make CLUSTER preserve recently-dead tuples per MVCC requirements > > I have not tested, but I suspect the table-rewriting variants of ALTER TABLE > have the same problem. Added. -- Bruce Momjian | http://candle.pha.pa.us pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
- References:
- Re: Does VACUUM reorder tables on clustered indices
- From: Tom Lane
- Re: Does VACUUM reorder tables on clustered indices
- Prev by Date: Re: Does VACUUM reorder tables on clustered indices
- Next by Date: EINTR error in SunOS
- Previous by thread: Re: Does VACUUM reorder tables on clustered indices
- Next by thread: EINTR error in SunOS
- Indexes: