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 по дате отправления: