| From: | Dmitry Samersoff <dms(at)wplus(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Index recreation in vacuum |
| Date: | 2000-01-18 19:30:34 |
| Message-ID: | 3884BF59.81329C8E@wplus.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
> >
> > The problem is how to invalidate/validate indexes.
> > Of cource natural way is to drop/create indexes but the
> > definition of indexes would be lost in case of abort/crash.
>
> 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.
--
Dmitry Samersoff, DM\S
dms(at)wplus(dot)net http://devnull.wplus.net
* There will come soft rains
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-01-18 19:36:37 | Re: [HACKERS] Index recreation in vacuum |
| Previous Message | Bruce Momjian | 2000-01-18 19:09:46 | Re: [PATCHES] docs done Re: [HACKERS] LIBPQ patches ... |