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 imp
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
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
m: Richard 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 initia
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 lik
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
