Horton

Re: 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>
Cc: Alexander Loginov <sas@mplik.ru>, pgsql-general@postgresql.org
Date: 2001-08-17T04:04:41Z
Lists: pgsql-general 
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > One backend would be blocked by another one because reindex_relation
> > calls reindex_index and reindex_index grabs an ExclusiveLock on the
> > relation.
> > Am I missing anything ?
> 
> It'd be okay if you *held* the lock throughout.  Grabbing and releasing
> it isn't safe IMHO. 

Maybe I'm slow on the uptake because I've just finished a
short vacation. Where do I release the lock ?

regards,
Hiroshi Inoue