Re: Proposed doc-patch: Identifying the Current WAL file

On Sat, 15 Apr 2006, Bruce Momjian wrote:

> Tom Lane wrote:
>
> No, I am not:
>
> $ touch x1 x2; touch x2
> $ sleep 2; ls -lt
> total 0
> -rw-r--r-- 1 root postgres 0 Apr 15 14:04 x1
> -rw-r--r-- 1 root postgres 0 Apr 15 14:04 x2
>
> If the write to x2 happens in the first second, but no later writes
> happen, you still see x1 as first, even though x2 is the new one and
> might have WAL data in it. The point is that the test does not have a
> one-second window of showing the wrong answer, meaning I could wait for
> 60 seconds, and still see the wrong WAL file at the top.

Bruce, what does

stat x1 x2

look like on your system? Which OS? Maybe we need caveats for various OSes?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954