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