| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Campbell, Lance" <lance(at)uiuc(dot)edu> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Recommended Initial Settings |
| Date: | 2007-02-23 17:19:00 |
| Message-ID: | 45DF2204.7010906@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 data files for the postgres database it would
> be redundant to have a large shared_buffers. Did I understand you
> correctly?
That's right - PG works with the O.S. This means it *might* not be a big
advantage to have a large shared_buffers.
On older versions of PG, the buffer management code wasn't great with
large shared_buffers values too.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2007-02-23 17:37:36 | Re: Using the 8.2 autovacuum values with 8.1 |
| Previous Message | Campbell, Lance | 2007-02-23 17:14:44 | Re: Recommended Initial Settings |