RE: Re[2]: Perfomance decreasing

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: Re[2]: Perfomance decreasing
Дата
Msg-id EKEJJICOHDIEMGPNIFIJIEHBFCAA.Inoue@tpf.co.jp
обсуждение исходный текст
Ответ на Re: Re[2]: Perfomance decreasing  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re[2]: Perfomance decreasing  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> Alexander Loginov <sas@mplik.ru> writes:
> >     I  have only one small question. Can I do REINDEX during inserting
> >     of  information  into  tables. Or I must block somehow updating of
> >     tables.
>
> Hmmm ... it looks like REINDEX only grabs AccessShareLock on the target
> relation, which seems very wrong.

Sorry I couldn't find where AccessShareLock is grabbed now.
AccessExclusiveLock is acquired in reindex_index but do you
mean it's too late ?

regards,
Hiroshi Inoue

В списке pgsql-general по дате отправления:

Предыдущее
От: newsreader@mediaone.net
Дата:
Сообщение: Re: why sequential scan
Следующее
От: John Clark Naldoza y Lopez
Дата:
Сообщение: Re: Killing inactive connections