Postgres Pro
Downloads
Home   >   mailing lists

Re: SET TRANSACTION in PL/pgSQL - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SET TRANSACTION in PL/pgSQL
Date
Msg-id 6a02a934-5f1e-d7a8-297a-46865876883e@2ndquadrant.com
Whole thread Raw
In response to Re: SET TRANSACTION in PL/pgSQL  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: SET TRANSACTION in PL/pgSQL  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation()
Next
From: Konstantin Knizhnik
Date:
Subject: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions