I would like to get someone's recommendations on the best initial
settings for a dedicated PostgreSQL server. I do realize that there are
a lot of factors that influence how one should configure a database. I
am just looking for a good starting point. Ideally I would like the
database to reside
Campbell, Lance wrote:
I would like to get someone's recommendations on the best initial
settings for a dedicated PostgreSQL server. I do realize that there are
a lot of factors that influence how one should configure a database. I
am just looking for a good starting point. Ideally I would
Huxton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23, 2007 10:29 AM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Recommended Initial Settings
Campbell, Lance wrote:
I would like to get someone's recommendations on the best initial
settings for a dedicated
Campbell, Lance wrote:
Richard,
Thanks for your reply.
You said:
Your operating-system should be doing the caching for you.
My understanding is that as long as Linux has memory available it will
cache files. Then from your comment I get the impression that since
Linux would be caching the
If you're doing much updating at all you'll also want to bump up
checkpoint_segments. I like setting checkpoint_warning just a bit under
checkpoint_timeout as a way to monitor how often you're checkpointing
due to running out of segments.
With a large shared_buffers you'll likely need to make the
In response to Campbell, Lance [EMAIL PROTECTED]:
Richard,
Thanks for your reply.
You said:
Your operating-system should be doing the caching for you.
My understanding is that as long as Linux has memory available it will
cache files. Then from your comment I get the impression that
