Re: Postgres query completion status? - Mailing list pgsql-performance

From Fernando Hevia
Subject Re: Postgres query completion status?
Date
Msg-id 69309F58C7734C079F93917CE5C404C7@iptel.com.ar
Whole thread Raw
In response to Re: Postgres query completion status?  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Postgres query completion status?  (Richard Neill <rn214@cam.ac.uk>)
List pgsql-performance

> -----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.



pgsql-performance by date:

Previous
From: Richard Neill
Date:
Subject: Re: Postgres query completion status?
Next
From: Richard Neill
Date:
Subject: Re: Postgres query completion status?