RE: Re[2]: Perfomance decreasing

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alexander Loginov" <sas(at)mplik(dot)ru>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Re[2]: Perfomance decreasing
Date: 2001-08-17 00:58:10
Message-ID: EKEJJICOHDIEMGPNIFIJIEHBFCAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> Alexander Loginov <sas(at)mplik(dot)ru> writes:
> > I have only one small question. Can I do REINDEX during inserting
> > of information into tables. Or I must block somehow updating of
> > tables.
>
> Hmmm ... it looks like REINDEX only grabs AccessShareLock on the target
> relation, which seems very wrong.

Sorry I couldn't find where AccessShareLock is grabbed now.
AccessExclusiveLock is acquired in reindex_index but do you
mean it's too late ?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Clark Naldoza y Lopez 2001-08-17 01:06:45 Re: Killing inactive connections
Previous Message newsreader 2001-08-17 00:11:29 Re: why sequential scan