Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0F1CF9F949D for ; Wed, 5 Sep 2007 18:24:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 01313-09 for ; Wed, 5 Sep 2007 18:24:35 -0300 (ADT) X-Greylist: delayed 00:22:17.097387 by SQLgrey-1.7.5 Received: from mail.planetcobalt.net (mail.planetcobalt.net [217.10.9.49]) by postgresql.org (Postfix) with ESMTP id CF7FD9F93E2 for ; Wed, 5 Sep 2007 18:24:34 -0300 (ADT) Received: by mail.planetcobalt.net (Postfix, from userid 1000) id 405BE3C00084; Wed, 5 Sep 2007 23:02:12 +0200 (CEST) Date: Wed, 5 Sep 2007 23:02:12 +0200 From: Ansgar -59cobalt- Wiechers To: pgsql-performance@postgresql.org Subject: Re: Performance on 8CPU's and 32GB of RAM Message-ID: <20070905210212.GA26941@mail.planetcobalt.net> References: <20070904230639.GA23731@alvh.no-ip.org> <46DE66CF.9000903@theendofthetunnel.de> <90bce5730709051016j5291827dx525d6b8fe4960fbd@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/61 X-Sequence-Number: 26606 On 2007-09-05 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. Uh... what? Locking isn't done by the filesystem but by applications (which certainly can decide to not lock a file when opening it). And no one in his right mind would ever have a virus scanner access the files of a running database, regardless of operating system or filesystem. Regards Angar Wiechers -- "The Mac OS X kernel should never panic because, when it does, it seriously inconveniences the user." --http://developer.apple.com/technotes/tn2004/tn2118.html