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

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Performance on 8CPU's and 32GB of RAM
Дата
Msg-id 82ir6mnb3s.fsf@mid.bfk.de
обсуждение исходный текст
Ответ на Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
* 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 по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: SAN vs Internal Disks
Следующее
От: Richard Yen
Дата:
Сообщение: postgres memory management issues?