Re: Suspending SELECTs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Suspending SELECTs
Дата
Msg-id 9997.1137435038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Suspending SELECTs  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-performance
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I wonder if we could have a way to "suspend" a transaction and restart
> it later in another backend.  I think we could do something like this
> using the 2PC machinery.
> Not that I'm up for coding it; just an idea that crossed my mind.

It's not impossible, perhaps, but it would require an order-of-magnitude
expansion of the 2PC machinery --- the amount of state associated with
an open execution plan is daunting.  I think there are discussions about
this in the archives.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Suspending SELECTs
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: Suspending SELECTs