Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 9D7A613FA3D7 for ; Mon, 18 Jun 2012 15:33:13 -0300 (ADT) Received: from exprod7og108.obsmtp.com ([64.18.2.169]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SgglD-0007Ju-SN for pgsql-hackers@postgresql.org; Mon, 18 Jun 2012 18:33:13 +0000 Received: from mail-lb0-f173.google.com ([209.85.217.173]) (using TLSv1) by exprod7ob108.postini.com ([64.18.6.12]) with SMTP ID DSNKT990WueAW2fwosO3UjSowGQDr/GuEEaJ@postini.com; Mon, 18 Jun 2012 11:33:11 PDT Received: by lbok6 with SMTP id k6so6138552lbo.18 for ; Mon, 18 Jun 2012 11:32:56 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding :x-gm-message-state; bh=NO58f/ESqi0PS8lB1CdafSiw+5TG00cvfgheZOUiVow=; b=S3/NcGvETu0yQmyF/L3oSxagOdFv2k0C4UzpDNzZZkZVuK7qTOozZBlKQF7dwJ2xFY RShJ4JfkL41RCcRKwV3RxonYU4ArAoc53c0GrWHYWOSUw8M2N+Lb684YCsZUl7fI01TX F3KnnygU5rTBhdqmn0F2JbbMKi0Mf34g5SHjPEZmTE2R8qlWURb1zJaFEzfAAMIGMVtu fVhvzZXjVvc/RZ4bi+ju6yaiXuVngmxPp2cAsCYEi/Jf9zi9uUSJTj6Hv12mo+dpVwnW HmUTp98sE3PkMkGDKHppF2hWnQA/1SpAc4u4hOKh9adztbgnRrLwkYmMqu0CelOAb5qh RO8w== Received: by 10.112.30.136 with SMTP id s8mr6951035lbh.51.1340044376682; Mon, 18 Jun 2012 11:32:56 -0700 (PDT) Received: from [192.168.1.100] (dsl-hkibrasgw2-ff6cc300-200.dhcp.inet.fi. [88.195.108.200]) by mx.google.com with ESMTPS id xx8sm28593868lab.10.2012.06.18.11.32.55 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 18 Jun 2012 11:32:55 -0700 (PDT) Message-ID: <4FDF7456.9010709@enterprisedb.com> Date: Mon, 18 Jun 2012 21:32:54 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 MIME-Version: 1.0 To: Andres Freund CC: pgsql-hackers@postgresql.org, Robert Haas Subject: Re: WAL format changes References: <4FDA5136.6080206@enterprisedb.com> <4FDF6E8E.4080900@enterprisedb.com> <201206182013.12868.andres@2ndquadrant.com> In-Reply-To: <201206182013.12868.andres@2ndquadrant.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQnp7D3oVa1nIbR7QJJvbbNProlodSjcwqledTwK4hOwtp/ZsLEDH1p391Cn8R7dstGXI9U+ X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201206/913 X-Sequence-Number: 209753 On 18.06.2012 21:13, Andres Freund wrote: > On Monday, June 18, 2012 08:08:14 PM Heikki Linnakangas wrote: >> The page header contains an XLogRecPtr (LSN), so if we change it we'll >> have to deal with pg_upgrade. I guess we could still keep XLogRecPtr >> around as the on-disk representation, and convert between the 64-bit >> integer and XLogRecPtr in PageGetLSN/PageSetLSN. I can try that out - >> many xlog calculations would admittedly be simpler if it was an uint64. > I am out of my depth here, not having read any of the relevant code, but > couldn't we simply replace the lsn from disk with InvalidXLogRecPtr without > marking the page dirty? > > There is the valid argument that you would loose some information when pages > with hint bits are written out again, but on the other hand you would also > gain the information that it was a hint-bit write... Sorry, I don't understand that. Where would you "replace the LSN from disk with InvalidXLogRecPtr" ? (and no, it probably won't work ;-) ) -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com