Re: Inadequate executor locking of indexes

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: Inadequate executor locking of indexes
Дата
Msg-id 23411878-a5c8-59f5-f30d-d2954bfe8ca2@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Inadequate executor locking of indexes  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Inadequate executor locking of indexes
Список pgsql-hackers
(this is not a reply to your full proposal, just something I thought to
point out)

On 2019/03/13 10:38, David Rowley wrote:
> i.e don't open the indexes for DELETEs.  I had ideas that maybe this
> could be changed to check the idxlockmode and open the indexes if it's
> above AccessSharedLock.  There didn't seem to be a very nice way to
> fetch the RangeTblEntry from the ResultRelInfo though,

Did you miss ri_RangeTableIndex?  It's the range table index of the result
relation for which a given ResultRelInfo is created.

Thanks,
Amit



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

Предыдущее
От: "Jamison, Kirk"
Дата:
Сообщение: RE: pg_upgrade: Pass -j down to vacuumdb
Следующее
От: "Matsumura, Ryo"
Дата:
Сообщение: RE: ECPG regression with DECLARE STATEMENT support