Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Joshua D. Drake <jd@commandprompt.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Martijn van Oosterhout <kleptog@svana.org>, Simon Riggs <simon@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, Greg Stark <gsstark@mit.edu>, Rod Taylor <pg@rbt.ca>, Qingqing Zhou <zhouqq@cs.toronto.edu>, pgsql-hackers@postgresql.org
Date: 2005-12-29T03:05:30Z
Lists: pgsql-hackers
now agree that the logging is more part of the table than > the command itself. Right now we have a COPY LOCK patch, but people are > going to want to control logging for INSERT INTO ... SELECT, and UPDATE, > and all sorts of other things, so I think we are best adding an ALTER > TABLE capability. I am thinking of this syntax: > > ALTER TABLE name RELIABILITY option > > where "option" is: > > DROP [ TABLE ON CRASH ] > DELETE [ ROWS ON CRASH ] > EXCLUSIVE > SHARE I would say ON FAILURE (Crash just seems way to scary :)) Joshua D. Drake