Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3642E9F9C03 for ; Thu, 6 Sep 2007 17:30:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 65231-04-6 for ; Thu, 6 Sep 2007 17:30:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id 6C98B9FA2A7 for ; Thu, 6 Sep 2007 17:30:39 -0300 (ADT) Received: from [80.229.150.39] (helo=mansionfamily.plus.com) by pih-relay06.plus.net with esmtp (Exim) id 1ITNzp-0007S8-Iq for pgsql-performance@postgresql.org; Thu, 06 Sep 2007 21:30:37 +0100 Received: from [192.168.0.87] ([192.168.0.87]:1671) by mansionfamily.plus.com with [XMail 1.22 ESMTP Server] id for from ; Thu, 6 Sep 2007 21:33:36 +0100 Message-ID: <46E0637F.2040800@mansionfamily.plus.com> Date: Thu, 06 Sep 2007 21:30:55 +0100 From: James Mansion User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Scott Marlowe CC: Trevor Talbot , pgsql-performance@postgresql.org Subject: Re: Performance on 8CPU's and 32GB of RAM References: <20070904230639.GA23731@alvh.no-ip.org> <46DE66CF.9000903@theendofthetunnel.de> <90bce5730709051016j5291827dx525d6b8fe4960fbd@mail.gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/99 X-Sequence-Number: 26644 Scott Marlowe wrote: > And there's the issue that with windows / NTFS that when one process > opens a file for read, it locks it for all other users. This means > that things like virus scanners can cause odd, unpredictable failures > of your database. > > Can you provide some justification for this? James