Re: Performance on 8CPU's and 32GB of RAM

From: Ansgar -59cobalt- Wiechers <lists(at)planetcobalt(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: 2007-09-05 21:02:12
Message-ID: 20070905210212.GA26941@mail.planetcobalt.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Trevor Talbot 2007-09-05 21:08:41 Re: Performance on 8CPU's and 32GB of RAM
Previous Message Scott Marlowe 2007-09-05 19:36:43 Re: Performance on 8CPU's and 32GB of RAM