| From: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general general <pgsql-general(at)postgresql(dot)org> |
| Cc: | ascot(dot)moss(at)gmail(dot)com |
| Subject: | Question About WAL filename and its time stamp |
| Date: | 2013-09-05 13:19:41 |
| Message-ID: | AE703685-2FBB-46D1-9264-6793C715C96E@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Evan Martin | 2013-09-05 13:49:04 | Re: Spurious error messages from pg_restore |
| Previous Message | Evan Martin | 2013-09-05 09:27:04 | Re: Spurious error messages from pg_restore |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2013-09-05 15:39:32 | Re: [PERFORM] Can you please suggest me some links where I can learn: |
| Previous Message | John R Pierce | 2013-09-05 05:25:46 | Re: Can you please suggest me some links where I can learn: |