|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]