Re: Cannot restart postgresql when increasing max_connections

From: "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com>
To: "Thom Brown" <thombrown(at)gmail(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot restart postgresql when increasing max_connections
Date: 2009-01-08 19:51:44
Message-ID: 8B319E5A30FF4A48BE7EEAAF609DB233021F3966@COMAIL01.digitalglobe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thom Brown wrote:
<...>
> I actually mentioned pgPool II to my boss earlier, and it's something we
> will have to seriously consider, but will have to do some research first.

We had an application ported from Informix which initially required 1000+ connections to handle peak load (one of 4 servers pushed by two application servers doing spatial queries).

Using pgPool means we have a max limit of 100 and have almost never gone near it -- usually we have 12-25 connections at once and load and throughput are higher than they were before.

Greg Williamson
Senior DBA
DigitalGlobe

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-01-08 20:06:25 Re: Cannot restart postgresql when increasing max_connections
Previous Message Will Rutherdale (rutherw) 2009-01-08 19:30:23 Re: to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?