Re: Perfomance decreasing - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: Perfomance decreasing
Date
Msg-id 3B7CA2F1.5266FDF3@tpf.co.jp
Whole thread Raw
In response to RE: Re[2]: Perfomance decreasing  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-general
Tom Lane wrote:
>
> 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.

Yes reindex_index is guarding itself.

> 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.

OK I would add a heap_open() to reindex_relation.
Please wait a while. I've not reorganized my local
source yet.

regards,
Hiroshi Inoue

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Perfomance decreasing
Next
From: Thomas Lockhart
Date:
Subject: Re: Max number of tables in a db?