Horton

Re: Perfomance decreasing

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Alexander Loginov <sas@mplik.ru>, pgsql-general@postgresql.org
Date: 2001-08-17T04:28:02Z
Lists: pgsql-general 
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
>> I'd say you shouldn't release it at all.

> As far as I see I'm not releasing it.

Oh, I hadn't looked closely at reindex_index.  Hmm... okay, you are
holding the lock acquired there.  But you're still acquiring it way too
late for my taste.  All of the setup work in reindex_relation seems to
be done without any lock.

			regards, tom lane