Horton

RE: Re[2]: Perfomance decreasing

Hiroshi Inoue <inoue@tpf.co.jp>

View thread View on postgr.es
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Alexander Loginov" <sas@mplik.ru>
Cc: <pgsql-general@postgresql.org>
Date: 2001-08-17T00:58:10Z
Lists: 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