Re: switch UNLOGGED to LOGGED - Mailing list pgsql-hackers

From Robert Haas
Subject Re: switch UNLOGGED to LOGGED
Date
Msg-id BANLkTikZx3kTA5TXfcLb=7k+KGTTOJ1xqg@mail.gmail.com
Whole thread Raw
In response to switch UNLOGGED to LOGGED  (Leonardo Francalanci <m_lists@yahoo.it>)
Responses Re: switch UNLOGGED to LOGGED  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
On Fri, Apr 8, 2011 at 6:01 AM, Leonardo Francalanci <m_lists@yahoo.it> wrote:
> 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?

I'm pretty sure we wouldn't accept a patch for a feature that would
only work with wal_level=minimal, but it might be a useful starting
point for someone else to keep hacking on.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade bug found!
Next
From: PostgreSQL - Hans-Jürgen Schönig
Date:
Subject: Re: k-neighbourhood search in databases