On Tue, Jul 9, 2013 at 2:01 AM, Jeison Bedoya <jeis...@audifarma.com.co> wrote: > max_connections = 900 > work_mem = 1024MB > maintenance_work_mem = 1024MB Aren't work_mem and maintenance_work_mem too high? You need to keep in mind that those are per-operation settings, so for example if you have 100 clients performing queries, this could grow up to 100G. In your case you even have a maximum of 900 connections... Do you perform heavy sort operations with your application that could explain such an amount of memory needed? -- Michael
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
