Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0F7C19FB301 for ; Fri, 7 Sep 2007 05:17:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 54555-03-7 for ; Fri, 7 Sep 2007 05:17:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id B3A919FB2F8 for ; Fri, 7 Sep 2007 05:17:34 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1ITZ1x-0002za-Cs; Fri, 07 Sep 2007 10:17:33 +0200 Received: from fweimer by bfk.de with local id 1ITZ1b-0004fm-An; Fri, 07 Sep 2007 10:17:11 +0200 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> From: Florian Weimer Date: Fri, 07 Sep 2007 10:17:11 +0200 In-Reply-To: (Scott Marlowe's message of "Wed, 5 Sep 2007 14:36:43 -0500") Message-ID: <82ir6mnb3s.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/113 X-Sequence-Number: 26658 * Scott Marlowe: > 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. I think most of them open the file in shared/backup mode. The only lock that is created by that guards deletion and renaming. It can still lead to obscure failures, but it's not a wholly-eclusive lock. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99