Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHZUh-00035l-6u for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 13:21:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VHZUg-0004MB-8q for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 13:21:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHZUe-0004M2-Uv for pgsql-general@postgresql.org; Thu, 05 Sep 2013 13:21:05 +0000 Received: from mail-pb0-x22e.google.com ([2607:f8b0:400e:c01::22e]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHZUT-0003zK-Ra for pgsql-general@postgresql.org; Thu, 05 Sep 2013 13:21:04 +0000 Received: by mail-pb0-f46.google.com with SMTP id rq2so1778242pbb.5 for ; Thu, 05 Sep 2013 06:20:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:mime-version:content-type:from:in-reply-to:date:cc :message-id:references:to; bh=DL/MfkSLPkMudQ+DBOJC8sT9JzMQL16uflTeseGYIak=; b=KSpO43EmFM1O2tSpoqEKL3f+e3GL1AmWziUlwjfnRRJgNgTQb5jNQmXwxag77M2wI3 yGemihTkx7yDLwuTcaml0DuPu1MrCBtR5KeJoTDVVQe/45I0IekGjwtnYAznKmmKa+rb Gro0PpKzPKczKE0jgRh5sSz7f1R7ykow6GElbscLmOVMN917Kwyq7TpELc9fVIqWjQ8D c0TxPlpvjqgTHOp++kUf+6NDFPMVh0MRhJl++thA3ybMJhUi4/Yg7pReAhqePKcIYbgi SAqAL5oIx675E8WbeCdeh911lyT3K5lxzjz76ZCDQb+mkO4uNEuj/Lt6YJszuCdKsipi obCA== X-Received: by 10.66.119.172 with SMTP id kv12mr9113773pab.34.1378387252171; Thu, 05 Sep 2013 06:20:52 -0700 (PDT) Received: from [172.31.1.109] ([211.155.168.89]) by mx.google.com with ESMTPSA id fy4sm35668249pbb.1.1969.12.31.16.00.00 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 05 Sep 2013 06:20:50 -0700 (PDT) Subject: Question About WAL filename and its time stamp Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: multipart/alternative; boundary=Apple-Mail-1-648023271 From: "ascot.moss@gmail.com" In-Reply-To: <522815DA.7070300@hogranch.com> Date: Thu, 5 Sep 2013 21:19:41 +0800 Cc: ascot.moss@gmail.com Message-Id: References: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se> <522815DA.7070300@hogranch.com> To: pgsql-general general X-Mailer: Apple Mail (2.1085) X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --Apple-Mail-1-648023271 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, =46rom the pg_xlog folder, I found some files with interesting time = stamps: older file names with newer timestamps, can you please advise = why? Set 1: How come 0000000400000F490000008D is 10 minutes newer than = 0000000400000F490000008E? -rw------- 1 111 115 16777216 Sep 4 15:28 0000000400000F490000008C -rw------- 1 111 115 16777216 Sep 4 15:27 0000000400000F490000008D <=3D=3D= =3D -rw------- 1 111 115 16777216 Sep 4 15:17 0000000400000F490000008E = <=3D=3D=3D=3D -rw------- 1 111 115 16777216 Sep 4 15:26 0000000400000F490000008F -rw------- 1 111 115 16777216 Sep 4 15:27 0000000400000F4900000090 Set 2: why files, 0000000400000F48000000FD, 0000000400000F48000000FE = and 0000000400000F4900000000, are not reused? 1) -rw------- 1 postgres postgres 16777216 Sep 4 23:07 = 0000000400000F48000000FA 2) -rw------- 1 postgres postgres 16777216 Sep 4 23:08 = 0000000400000F48000000FB 3) -rw------- 1 postgres postgres 16777216 Sep 4 23:09 = 0000000400000F48000000FC <=3D=3D=3D 4) -rw------- 1 postgres postgres 16777216 Sep 4 14:47 = 0000000400000F48000000FD <=3D=3D=3D=3D 5) -rw------- 1 postgres postgres 16777216 Sep 4 14:46 = 0000000400000F48000000FE 6) -rw------- 1 postgres postgres 16777216 Sep 4 14:46 = 0000000400000F4900000000 regards= --Apple-Mail-1-648023271 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi,

=46rom = the pg_xlog folder, I found some files with interesting time stamps: = older file names with newer timestamps, can you please advise = why?

Set 1: How = come 0000000400000F490000008D is 10 minutes newer than = 0000000400000F490000008E?
-rw------- 1 111 115 16777216 = Sep  4 15:28 0000000400000F490000008C
-rw------- 1 111 = 115 16777216 Sep  4 15:27 0000000400000F490000008D = <=3D=3D=3D
-rw------- 1 111 115 16777216 Sep =  4 15:17 0000000400000F490000008E = <=3D=3D=3D=3D
-rw------- 1 111 115 16777216 Sep  4 = 15:26 0000000400000F490000008F
-rw------- 1 111 115 16777216 = Sep  4 15:27 = 0000000400000F4900000090

Set 2: why = files,  0000000400000F48000000FD, =  0000000400000F48000000FE and 0000000400000F4900000000, are = not reused?
1) -rw------- 1 postgres postgres 16777216 = Sep  4 23:07 0000000400000F48000000FA
2) -rw------- 1 = postgres postgres 16777216 Sep  4 23:08 = 0000000400000F48000000FB
3) -rw------- 1 postgres postgres = 16777216 Sep  4 23:09 0000000400000F48000000FC =  <=3D=3D=3D
4) -rw------- 1 postgres postgres 16777216 Sep  4 = 14:47 0000000400000F48000000FD  <=3D=3D=3D=3D
5) = -rw------- 1 postgres postgres 16777216 Sep  4 14:46 = 0000000400000F48000000FE
6) -rw------- 1 postgres postgres = 16777216 Sep  4 14:46 = 0000000400000F4900000000

regards= --Apple-Mail-1-648023271--