Skip site navigation (1) Skip section navigation (2)

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: 2005-12-24 03:00:39
Message-ID: 11802.1135393239@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2005-12-24 03:29:50
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Previous:From: Qingqing ZhouDate: 2005-12-24 02:37:42
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group