Re: Removal of currtid()/currtid2() and some table AM cleanup

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Removal of currtid()/currtid2() and some table AM cleanup
Дата
Msg-id 20200624021110.GA130132@paquier.xyz
обсуждение исходный текст
Ответ на Re: Removal of currtid()/currtid2() and some table AM cleanup  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Removal of currtid()/currtid2() and some table AM cleanup  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Re: Removal of currtid()/currtid2() and some table AM cleanup  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список pgsql-hackers
On Tue, Jun 23, 2020 at 02:02:33PM +0900, Michael Paquier wrote:
> Actually, while reviewing the code, the only code path where we use
> currtid2() involves positioned_load() and LATEST_TUPLE_LOAD.  And the
> only location where this happens is in SC_pos_reload_with_key(), where
> I don't actually see how it would be possible to not have a keyset and
> still use a CTID, which would led to LATEST_TUPLE_LOAD being used.  So
> could it be possible that the code paths of currtid2() are actually
> just dead code?

I have dug more into this one, and we actually stressed this code path
quite a lot up to commit d9cb23f in the ODBC driver, with tests
cursor-block-delete, positioned-update and bulkoperations particularly
when calling SQLSetPos().  However, 86e2e7a has reworked the code in
such a way that we visibly don't use anymore CTIDs if we don't have a
keyset, and that combinations of various options like UseDeclareFetch
or UpdatableCursors don't trigger this code path anymore.  In short,
currtid2() does not get used.  Inoue-san, Saito-san, what do you
think?  I am adding also Tsunakawa-san in CC who has some experience
in this area.
--
Michael

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Threading in BGWorkers (!)
Следующее
От: David Rowley
Дата:
Сообщение: Re: Default setting for enable_hashagg_disk