| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Time travel? |
| Date: | 2016-09-29 19:06:25 |
| Message-ID: | CANu8Fiy5Lya3Qre6oekwamM_5BJsbabwSSOpNXRtTXYaNqMTjA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
*So here is a strange question. I am using PostgreSQL 9.4.0 (Yes, I know
9.4.9 is most recent but it's out of my control) O/S is AWS Debian 3.16.7-2
(2014-11-06) x86_64 GNU/Linux. I list the creation time for a WAL file and
it shows: /home/mdavidson/dba$ ls -l --time=ctime
/d-log/pg_xlog/000000010000000D000000C9-rw------- 1 postgres postgres
16777216 Sep 29 07:14 /d-log/pg_xlog/000000010000000D000000C9but then I
list the access time for a WAL file and it shows: /home/mdavidson/dba$ ls
-l --time=atime /d-log/pg_xlog/000000010000000D000000C9-rw------- 1
postgres postgres 16777216 Sep 7 14:33
/d-log/pg_xlog/000000010000000D000000C9How is it possible for the WAL file
to be accessed BEFORE it was created?Am I overlooking something simple?*
*Melvin Davidson*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-09-29 19:17:13 | Re: Time travel? |
| Previous Message | Grigory Smolkin | 2016-09-29 15:10:11 | Re: Сreate parallel aggregate |