Re: Nested transactions: low level stuff

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Nested transactions: low level stuff
Дата
Msg-id 13049.1048261314@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Nested transactions: low level stuff  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Nested transactions: low level stuff  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>     Do we want UNDO just for subtransactions?
> That was pretty easily defeated, though I made an argument that you
> could do UNDO pretty cheaply when you have WAL ensuring crash recovery.

That argument was what got us into the early-7.1 WAL bloat problems.
I don't think it's "pretty cheap" to have to hold the entire WAL for the
length of your longest-running transactions.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: ALTER TABLE / CLUSTER ON
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE / CLUSTER ON