Postgres Pro
Downloads
Home   >   mailing lists

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

From Florian Weimer
Subject Re: Performance on 8CPU's and 32GB of RAM
Date
Msg-id 82ir6mnb3s.fsf@mid.bfk.de
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
Tree view 
* 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.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: SAN vs Internal Disks
Next
From: Richard Yen
Date:
Subject: postgres memory management issues?