> > My idea would be to create a new index that is a random index name.
> > Then, do rename(), which is an atomic OS operation putting the new index
> > file in place of the old name. Seems that would work well.
>
> Yes, but it can cause disk space problem for very large indices.
> Moreover, you need firts unlink old index file than do rename(),
> it is not atomic.
>
> May be better way is to create tmp file containing index description,
> undestandable for vacuum.
The beauty of doing a temp index while keeping the old one is that you
can recover right away, and maybe allow the old index to be used while
you vacuum?
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026