| 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 20:24:44 |
| Message-ID: | 3884CC0C.B6DF19A2@wplus.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
> [Charset koi8-r unsupported, filtering to ASCII...]
> > 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.
>
> Well, one would hope you have enough disk space free for that.
At least noticed by vacuum
> ...
> Rename() causes the link named from to be renamed as to. If to exists, it
> is first removed. Both from and to must be of the same type (that is,
Ok. I agree.
--
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 20:45:47 | Re: [HACKERS] Index recreation in vacuum |
| Previous Message | Alfred Perlstein | 2000-01-18 19:53:04 | Re: [PATCHES] docs done Re: [HACKERS] LIBPQ patches ... |