"A.M." <age...@themactionfaction.com> writes: > On Apr 11, 2011, at 7:13 PM, Tom Lane wrote: >> Robert Haas <robertmh...@gmail.com> writes: >>> I mean I'm not convinced that fcntl() locking will be as reliable.
>> I'm not either. Particularly not on NFS. > Is there an example of a recent system where fcntl is broken (ignoring NFS)? Well, the fundamental point is that "ignoring NFS" is not the real world. We can't tell people not to put data directories on NFS, and even if we did tell them not to, they'd still do it. And NFS locking is not trustworthy, because the remote lock daemon can crash and restart (forgetting everything it ever knew) while your own machine and the postmaster remain blissfully awake. None of this is to say that an fcntl lock might not be a useful addition to what we do already. It is to say that fcntl can't just replace what we do already, because there are real-world failure cases that the current solution handles and fcntl alone wouldn't. regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers