Postgres Pro
Downloads
Home   >   mailing lists

good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9 - Mailing list pgsql-general

From AI Rumman
Subject good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Date
Msg-id AANLkTi=qCyojFzQY1mfXrEuCQgphTZSy1OKrJRH-uArZ@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Allan Kamau
Date:
Subject: Considering Solid State Drives
Next
From: "Markus Wollny"
Date:
Subject: Re: Problem with to_tsquery() after restore on PostgreSQL 9.0.1