On Thu, Mar 1, 2012 at 4:23 PM, Claudio Freire <[email protected]> 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 -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
