On 01/21/2013 03:45 PM, Tim Uckun wrote:
Oh I forgot ... "shared_buffers";"1600kB";"configuration file"
You *reduced* shared buffers to 1.6MB? IIRC the typical default is 32MB and the most common adjustment is to *increase* shared buffers. Most of my servers are set to 2GB.
Try bumping that up to a reasonable value (http://www.postgresql.org/docs/9.2/static/runtime-config-resource.html) and share the results. Don't forget to restart PG after changing that setting.
Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
