> -----Mensaje original----- > De: Richard Neill > > > max_connections = 500 # (change requires restart) > work_mem = 256MB # min 64kB
Not that it has to do with your current problem but this combination could bog your server if enough clients run sorted queries simultaneously. You probably should back on work_mem at least an order of magnitude. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
