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 11802.1135393239@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>)
Responses Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Qingqing Zhou <zhouqq@cs.toronto.edu> writes:
> I revised the idea with MINIMAL XLOG (instead of WITHOUT XLOG) like the
> below. I think in this way, we can always gaurantee its correctness and
> can always improve it.

I think the entire idea is a waste of time anyway.  If we have the COPY
case covered then we have done the only case that has any practical use
AFAICS --- you don't use UPDATE or DELETE for bulk loads, and you don't
use retail INSERTs either if you are striving for speed.

I don't want to see us mucking with the WAL logic without a *whole* lot
better rationale than has been presented so far.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Next
From: Qingqing Zhou
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and