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

From Simon Riggs
Subject Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Date
Msg-id 1135598607.2964.702.camel@localhost.localdomain
Whole thread Raw
In response to Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
On Sat, 2005-12-24 at 10:32 -0500, Tom Lane wrote:

> An ALTER TABLE SET LOGGED/UNLOGGED switch might have some merit, but
> please don't muddy the waters by confusing this with temp-table
> status.

I would not be against such a table-level switch, but the exact
behaviour would need to be specified more closely before this became a
TODO item, IMHO.

If someone has a 100 GB table, they would not appreciate the table being
truncated if a transaction to load 1 GB of data aborts, forcing recovery
of the 100 GB table.

Best Regards, Simon Riggs





pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fixing row comparison semantics
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and