On Mon, Feb 17, 2014 at 8:31 AM, Stephen Frost <sfr...@snowman.net> wrote: >> Actually, I object to increasing work_mem by default. In my experience >> most of the untuned servers are backing some kind of web application and >> often run with far too many connections. Increasing work_mem for those >> is dangerous. > > And I still disagree with this- even in those cases. Those same untuned > servers are running dirt-simple queries 90% of the time and they won't > use any more memory from this, while the 10% of the queries which are > more complicated will greatly improve.
+1 -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers