good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9

Поиск
Список
Период
Сортировка
От AI Rumman
Тема good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Дата
Msg-id AANLkTi=qCyojFzQY1mfXrEuCQgphTZSy1OKrJRH-uArZ@mail.gmail.com
обсуждение исходный текст
Ответы Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9  (tuanhoanganh <hatuan05@gmail.com>)
Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9  (Vick Khera <vivek@khera.org>)
Список pgsql-general
Дерево обсуждения
I am going to install Postgresql 9.0 for my running applicaiton which is at 8.1.
My Db size is 3 GB.
Server Specification:
  dual-core 4 cpu
  RAM: 32 GB
  OS: Centos
What will be good settings for DB parameters such as shared_buffers, checkpoint_segment and etc.
Any help please.

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

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Considering Solid State Drives
Следующее
От: "Markus Wollny"
Дата:
Сообщение: Re: Problem with to_tsquery() after restore on PostgreSQL 9.0.1