On Thu, Mar 1, 2012 at 4:23 PM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> For a read-only database, as was discussed, a lower shared_buffers
> settings makes sense. And 128M is low enough, I'd guess.
>
> Setting work_mem to hundreds of MB in a 4G system is suicide. Tens
> even is dangerous.
>
Why do you say that? We've had work_mem happily at 100MB for years. Is
there a particular degenerate case you're concerned about?
-p
--
Peter van Hardenberg
San Francisco, California
"Everything was beautiful, and nothing hurt." -- Kurt Vonnegut