Re: 100 simultaneous connections, critical limit?

From: Adam Alkins <postgresql(at)rasadam(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 100 simultaneous connections, critical limit?
Date: 2004-01-14 18:10:14
Message-ID: 40058606.10605@rasadam.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

scott.marlowe wrote:

>A few tips from an old PHP/Apache/Postgresql developer.
>
>1: Avoid pg_pconnect unless you are certain you have load tested the
>system and it will behave properly. pg_pconnect often creates as many
>issues as it solves.
>
>

I share the above view. I've had little success with persistent
connections. The cost of pg_connect is minimal, pg_pconnect is not a
viable solution IMHO. Connections are rarely actually reused.

--
Adam Alkins
http://www.rasadam.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-01-14 18:13:30 Re: COUNT & Pagination
Previous Message scott.marlowe 2004-01-14 17:09:23 Re: 100 simultaneous connections, critical limit?