Re: [HACKERS] Index recreation in vacuum

> > 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026