Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Дата
Msg-id 8748.1135297769@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Список pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> BEGIN TRANSACTION WITHOUT XLOG;    /* forbidden vacuum, PITR etc */

> So during this peroid, if any transaction failed, the only consequence is 
> add invisible garbage data.

No, the likely consequence is irretrievable corruption of any table or
index page touched by the transaction.  You're going to have a very hard
time selling this as a good idea.
        regards, tom lane


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

Предыдущее
От: Ashok Agrawal
Дата:
Сообщение: Re: Oracle PL/SQL Anonymous block equivalent in postgres
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Oracle PL/SQL Anonymous block equivalent in postgres