> Start at the top of the table, go to the first 'blank' section (a deleted
> record)...find the next good record that will fit in the space, move it
> there...clear out the old space, etc...
>
> if dba issues a 'vacuum', lock the table and do all records at once, but
> otherwise try and vacuum the table live...
>
> With the new MVCC serialization, this concept should be less intrusive on
> readers, no?
Wish I knew the answer. I can guess, but that isn't going to help.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026