Re: SET TRANSACTION in PL/pgSQL

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: SET TRANSACTION in PL/pgSQL
Дата
Msg-id 6a02a934-5f1e-d7a8-297a-46865876883e@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: SET TRANSACTION in PL/pgSQL  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Ответы Re: SET TRANSACTION in PL/pgSQL  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
On 3/15/18 17:49, Alexander Korotkov wrote:
> I didn't dig deeply into this subject.  But should we rather teach SPI
> to execute
> utility statements without taking snapshot when not necessary.  That seems
> like what executor do for client provided queries.  And that seems a bit
> unlogical
> that SPI behaves differently.

Here is the same patch rewritten using SPI, using the new no_snapshots
facility recently introduced.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation()
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions