Fernando Hevia wrote:
-----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.
What's the correct way to configure this?
* We have one client which needs to run really big transactions
(therefore needs the work memory).
* We also have about 200 clients which run always very small, short queries.
Richard
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
