RE: Re[2]: Perfomance decreasing - Mailing list pgsql-general

From Hiroshi Inoue
Subject RE: Re[2]: Perfomance decreasing
Date
Msg-id EKEJJICOHDIEMGPNIFIJIEHBFCAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: Re[2]: Perfomance decreasing  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re[2]: Perfomance decreasing
List pgsql-general
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> Alexander Loginov <sas@mplik.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

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: why sequential scan
Next
From: John Clark Naldoza y Lopez
Date:
Subject: Re: Killing inactive connections