Re: Perfomance decreasing - Mailing list pgsql-general

From Tom Lane
Subject Re: Perfomance decreasing
Date
Msg-id 28596.998022482@sss.pgh.pa.us
Whole thread Raw
In response to Re: Perfomance decreasing  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List 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

pgsql-general by date:

Previous
From: bpalmer
Date:
Subject: Max number of tables in a db?
Next
From: Hiroshi Inoue
Date:
Subject: Re: Perfomance decreasing