Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9C0FC475CED for ; Sat, 25 Jan 2003 11:16:22 -0500 (EST) Received: from sss.pgh.pa.us (sss-backup.pgh.pa.us [216.151.103.158]) by postgresql.org (Postfix) with ESMTP id 3F511475CB4 for ; Sat, 25 Jan 2003 11:16:21 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0PGGC5u010918; Sat, 25 Jan 2003 11:16:12 -0500 (EST) To: Curt Sampson Cc: Kevin Brown , pgsql-hackers@postgresql.org Subject: Re: WAL replay logic (was Re: [PERFORM] Mount options for Ext3?) In-reply-to: References: <200301241120.14404.josh@agliodbs.com> <20030125003011.GA28252@filer> <28176.1043457408@sss.pgh.pa.us> <20030125021159.GC28252@filer> <1260.1043463535@sss.pgh.pa.us> <20030125041319.GE28252@filer> <6917.1043473233@sss.pgh.pa.us> Comments: In-reply-to Curt Sampson message dated "Sat, 25 Jan 2003 16:59:17 +0900" Date: Sat, 25 Jan 2003 11:16:12 -0500 Message-ID: <10916.1043511372@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/946 X-Sequence-Number: 34556 Curt Sampson writes: > On Sat, 25 Jan 2003, Tom Lane wrote: >> We'd have to take it on faith that we should replay the visible files >> in their name order. > Couldn't you could just put timestamp information at the beginning if > each file, Good thought --- there's already an xlp_pageaddr field on every page of WAL, and you could examine that to be sure it matches the file name. If not, the file csn be ignored. regards, tom lane