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

Re: switch UNLOGGED to LOGGED

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: switch UNLOGGED to LOGGED
Date: 2011-05-30 07:51:14
Message-ID: 185396.99996.qm@web29005.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> Why is it necessary to replay the operation only on the slave?   Can we
> just use XLOG_HEAP_NEWPAGE?


Uh, I don't know why but I thought I shouldn't log a page on the master,
since all the pages are already there and fsync-ed. But if it makes no harm,
I can easily use   XLOG_HEAP_NEWPAGE (of course, only in the 
 wal_level != minimal case).

In response to

pgsql-hackers by date

Next:From: Tomasz ChmielewskiDate: 2011-05-30 09:18:17
Subject: Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?
Previous:From: Greg StarkDate: 2011-05-30 05:42:48
Subject: Re: Getting a bug tracker for the Postgres project

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