From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, will trillich <will(at)serensoft(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: unbalanced indexes -> fixed via dump/restore? |
Date: | 2001-03-09 01:27:59 |
Message-ID: | 3AA8319F.659F4B0C@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alfred Perlstein wrote:
>
> * Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> [010308 17:07] wrote:
> > Tom Lane wrote:
> > >
> > > btw, REINDEX essentially does the same thing as the above,
> >
> > Yes REINDEX is safe under postmaster in 7.1.
> > In addtion REINDEX has some advantages.
> > 1) no necessity to scatter the index definition.
> > 2) it doesn't change any reference among system objects.
> >
> > > but there's
> > > a lot of strange additional locking code in it,which I don't trust
> > > much... call it a design disagreement with Hiroshi ;-)
> > >
> >
> > Is it LockClassForUpdate() ? If so it's never a special function.
> > It's only implementing a 'FOR UPDATE' part of 'SELECT .. FROM PG_CLASS'
> > and 'select .. for update' before 'update ..' is an oridinary
> > sequence of update operations.
>
> Is there a way to do this under 7.0.3?
>
REINDEX for user tables is available in 7.0.3 but it isn't
safe because it must overwrite the existent index files.
Regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel J. Kressin | 2001-03-09 01:46:36 | table name case sensitivity |
Previous Message | Alfred Perlstein | 2001-03-09 01:08:41 | Re: unbalanced indexes -> fixed via dump/restore? |