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

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

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