pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: ascot.moss@gmail.com <ascot.moss@gmail.com>
To: pgsql-general general <pgsql-general@postgresql.org>
Cc: ascot.moss@gmail.com
Subject: Question About WAL filename and its time stamp
Date: Thu, 5 Sep 2013 21:19:41 +0800
Message-ID: <AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com> (raw)
In-Reply-To: <522815DA.7070300@hogranch.com>
References: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se>
	<522815DA.7070300@hogranch.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

Hi,

From 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 <===
-rw------- 1 111 115 16777216 Sep  4 15:17 0000000400000F490000008E <====
-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  <===
4) -rw------- 1 postgres postgres 16777216 Sep  4 14:47 0000000400000F48000000FD  <====
5) -rw------- 1 postgres postgres 16777216 Sep  4 14:46 0000000400000F48000000FE
6) -rw------- 1 postgres postgres 16777216 Sep  4 14:46 0000000400000F4900000000

regards=

view thread (3+ messages)  latest in thread

Message-ID: <AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com>
Permalink:  ../AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com/
Also on:    postgresql.org/message-id/AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ascot.moss@gmail.com, pgsql-general@postgresql.org
  Subject: Re: Question About WAL filename and its time stamp
  In-Reply-To: <AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox