Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Date
Msg-id 8748.1135297769@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List 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 by date:

Previous
From: Ashok Agrawal
Date:
Subject: Re: Oracle PL/SQL Anonymous block equivalent in postgres
Next
From: Bruce Momjian
Date:
Subject: Re: Oracle PL/SQL Anonymous block equivalent in postgres