Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Date: Fri, 23 Dec 2005 22:00:39 -0500
- Message-id: <11802(dot)1135393239(at)sss(dot)pgh(dot)pa(dot)us>
Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)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
- References:
- WAL bypass for INSERT, UPDATE and DELETE?
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and DELETE?
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and DELETE?
- From: Martijn van Oosterhout
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Home |
Main Index |
Thread Index