On 03/01/2012 05:52 PM, Stefan Keller wrote:
These are the current modified settings in postgresql.conf: shared_buffers = 128MB work_mem = 3MB
These are extremely low settings on virtually any modern computer. I usually look to set shared buffers in numbers of Gb and work_mem at least in tens if not hundreds of Mb for any significantly sized database.
cheers andrew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
