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

Поиск
Список
Период
Сортировка
От Nicolai Tufar
Тема Re: Urgent need of (paid) PostgreSQL support in New
Дата
Msg-id 028901c2a103$69998dc0$8016a8c0@apb.com.tr
обсуждение исходный текст
Ответ на Urgent need of (paid) PostgreSQL support in New York City area  (Doug Fields <dfields-pg-general@pexicom.com>)
Ответы Re: Urgent need of (paid) PostgreSQL support in New  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Urgent need of (paid) PostgreSQL support in New  ("Ricardo Ryoiti S. Junior" <suga@netbsd.com.br>)
Список pgsql-general
Дерево обсуждения 
----- Original Message -----
From: "Doug Fields" <dfields-pg-general@pexicom.com>
>
> We have 8GB RAM. I've allocated about 700 megs to shared memory. The rest
> is buffer cached by the O/S. I can't afford a 32 gig server as 2 gig RAM
> modules are exorbitantly expensive. The database won't fit into RAM
anyway.

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.

Regards,
Nic

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

Предыдущее
От: Han Holl
Дата:
Сообщение: Re: Postgresql and Ruby - any opensource software done with these two ?
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Urgent need of (paid) PostgreSQL support in New