On Thu, Mar 1, 2012 at 4:23 PM, Claudio Freire <klaussfreire@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance