Re: Postgres query completion status?

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: "'Richard Neill'" <rn214(at)cam(dot)ac(dot)uk>, "'Thom Brown'" <thombrown(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgres query completion status?
Date: 2009-11-20 21:07:28
Message-ID: 69309F58C7734C079F93917CE5C404C7@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Neill 2009-11-20 21:12:15 Re: Postgres query completion status?
Previous Message Richard Neill 2009-11-20 20:45:10 Re: Postgres query completion status?