On Tue, Dec 27, 2011 at 9:14 AM, Andrew Dunstan <and...@dunslane.net> wrote: > It depends on the workload. Your 16M setting would make many of my clients' > systems slow to an absolute crawl for some queries, and they don't run into > swap issues, because we've made educated guesses about usage patterns.
Exactly. I've had an old Pentium4 machine that did reporting and only had 2G RAM with a 256M work_mem setting, while the heavily loaded machine I mentioned earlier handles something on the order of several hundred concurrent users and thousands of queries a second, and 16Meg was a pretty big setting on that machine, but since most of the queries were of the select * from sometable where pkid=123456 it wasn't too dangerous. It's all about the workload. For that, we need more info from the OP. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
