Re: autonomous transactions

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: autonomous transactions
Дата
Msg-id CAM-w4HPT9gshY7joF0rwYrtpCb+Q2rzSMJ0Kz6BeLZ2c9hzTQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: autonomous transactions  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Aug 31, 2016 at 3:11 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
>
> I suspect that there'll be way too much code that relies on stashing
> xact-scoped stuff in globals for that to be viable. Caches alone.
> Peter will be able to explain more, I'm sure.
>
> We'd probably need a new transaction data object that everything
> xact-scoped hangs off, so we can pass it everywhere or swap it out of
> some global. The mechanical refactoring alone would be pretty scary,
> not to mention the complexity of actually identifying all the less
> obvious places that need changing.

Well this is the converse of the same problem. Today process state and
transaction are tied together. One way or another you're trying to
split that -- either by having two processes share state or by having
one process manage two transactions.

I suppose we already have the infrastructure for parallel query so
there's at least some shared problem space there.

-- 
greg



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: psql \setfileref
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Patch: Write Amplification Reduction Method (WARM)