Re: Perfomance decreasing

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Perfomance decreasing
Дата
Msg-id 3B7CA2F1.5266FDF3@tpf.co.jp
обсуждение исходный текст
Ответ на RE: Re[2]: Perfomance decreasing  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Perfomance decreasing
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: Max number of tables in a db?