Re: Caching by Postgres - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Caching by Postgres
Date
Msg-id 200508231057.09885.josh@agliodbs.com
Whole thread Raw
In response to Re: Caching by Postgres  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
John,

> So I'm guessing that with 8.1 there would be 2 sweet spots. Low
> shared_buffers (<= 10k), and really high shared buffers (like all of
> available ram).
> But because postgres has been tuned for the former I would stick with it
> (I don't think shared_buffers can go >2GB, but that might just be
> work_mem/maintenance_work_mem).

I'll be testing this as soon as we get some issues with the 64bit
shared_buffer patch worked out.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Caching by Postgres
Next
From: Donald Courtney
Date:
Subject: Re: Caching by Postgres