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