Re: Urgent need of (paid) PostgreSQL support in New

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Urgent need of (paid) PostgreSQL support in New
Дата
Msg-id 3DF7681F.25272.471305C@localhost
обсуждение исходный текст
Ответ на Re: Urgent need of (paid) PostgreSQL support in New  ("Nicolai Tufar" <ntufar@apb.com.tr>)
Ответы Re: Urgent need of (paid) PostgreSQL support in New
Re: Urgent need of (paid) PostgreSQL support in New
Список pgsql-general
On 11 Dec 2002 at 12:52, Nicolai Tufar wrote:

> OS caching is generally considered a waste of resource in databases.
> Try to allocate as much as possible to shared buffers and set OS caching
> to minimum.

That is an exactly opposite of the truth. Leave as much for OS cache and do
minimum use of shared buffers.

Initially upping the shared buffers help but at some pointthe advantage starts
to disappear. Decide that figure with trial and error but certainly it will be
around 100-200MB for most cases..

Bye
 Shridhar

--
Intuition, however illogical, is recognized as a command prerogative.        -- Kirk,
"Obsession", stardate 3620.7


В списке pgsql-general по дате отправления: