Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 8910F2E00E1 for ; Mon, 31 Mar 2008 17:53:51 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 10937-05 for ; Mon, 31 Mar 2008 17:53:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay04.plus.net (pih-relay04.plus.net [212.159.14.131]) by developer.postgresql.org (Postfix) with ESMTP id 68EF62E00E0 for ; Mon, 31 Mar 2008 17:53:46 -0300 (ADT) Received: from [80.229.150.39] (helo=mansionfamily.plus.com) by pih-relay04.plus.net with esmtp (Exim) id 1JgR0h-0006qp-S3 for pgsql-performance@postgresql.org; Mon, 31 Mar 2008 21:53:44 +0100 Received: from [192.168.0.89] ([192.168.0.89]:1260) by mansionfamily.plus.com with [XMail 1.22 ESMTP Server] id for from ; Mon, 31 Mar 2008 21:58:37 +0100 Message-ID: <47F15043.4090401@mansionfamily.plus.com> Date: Mon, 31 Mar 2008 21:57:39 +0100 From: James Mansion Organization: MsgWare User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Mark Mielke CC: pgsql-performance@postgresql.org Subject: Re: POSIX file updates References: <47F1413B.40109@mansionfamily.plus.com> <47F1436D.4030905@mark.mielke.cc> In-Reply-To: <47F1436D.4030905@mark.mielke.cc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 50c56827f087ddabc9fce1d8a537112e X-Archive-Number: 200803/532 X-Sequence-Number: 29486 > I don't believe POSIX has any restriction such as you describe - or if > it does, and I don't know about it, then most UNIX file systems (if > not most file systems on any platform) are not POSIX compliant. > I suspect that indeed there are two different issues here in that the file mutex relates to updates to the file, not passing the buffers through into the drive, which indeed might be delayed. Been using direct io too much recently. :-(