Re: Caching by Postgres

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: John A Meinel <john(at)arbash-meinel(dot)com>, gokulnathbabu manoharan <gokulnathbabu(at)yahoo(dot)com>
Subject: Re: Caching by Postgres
Date: 2005-08-23 17:57:09
Message-ID: 200508231057.09885.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Donald Courtney 2005-08-23 18:41:39 Re: Caching by Postgres
Previous Message Frank Wiles 2005-08-23 17:43:23 Re: Caching by Postgres