Re: Performance on 8CPU's and 32GB of RAM - Mailing list pgsql-performance

From Ansgar -59cobalt- Wiechers
Subject Re: Performance on 8CPU's and 32GB of RAM
Date
Msg-id 20070905210212.GA26941@mail.planetcobalt.net
Whole thread Raw
In response to Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: Performance on 8CPU's and 32GB of RAM
Next
From: "Scott Marlowe"
Date:
Subject: Re: Performance on 8CPU's and 32GB of RAM