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 <[EMAIL PROTECTED]> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
