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

switch UNLOGGED to LOGGED

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: switch UNLOGGED to LOGGED
Date: 2011-04-08 10:01:38
Message-ID: 831695.27653.qm@web29019.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I read the discussion at 


http://archives.postgresql.org/pgsql-hackers/2011-01/msg00315.php 


From what I can understand, going from/to unlogged to/from logged in
the wal_level == minimal case is not too complicated. 

Suppose I try to write a patch that allows 

ALTER TABLE tablename SET LOGGED (or UNLOGGED)
(proper sql wording to be discussed...)

only in the wal_level == minimal case: would it be accepted as a
"first step"? Or rejected because it doesn't allow it in the other
cases?

From what I got in the discussion, handling the other wal_level cases
can be very complicated (example: the issues in case "we *crash*
without writing an abort record").




Leonardo

Responses

pgsql-hackers by date

Next:From: Noah MischDate: 2011-04-08 11:08:13
Subject: Re: pg_upgrade bug found!
Previous:From: Brendan JurdDate: 2011-04-08 09:00:22
Subject: Re: Failed assert ((data - start) == data_size) in heaptuple.c

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