Skip site navigation (1) Skip section navigation (2)

Re: Tuning 8.3

From: "Christopher Browne" <cbbrowne(at)gmail(dot)com>
To: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tuning 8.3
Date: 2008-02-25 19:58:18
Message-ID: d6d6637f0802251158s2ccbee7dq2d23d95be4065333@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
"Get thee to a connection pooler ASAP."

We've got systems where we establish ~1K connections, but that's on
UNIX, where the handling of large systems is *WAY* more mature than
Windows.

Any time those kinds of quantities of connections appear necessary, it
seems highly preferable to be using connection pooling so as to try to
reduce the number of actual connections and to increase the
per-connection usage.

-- 
http://linuxfinances.info/info/linuxdistributions.html
"The definition of insanity is doing the same thing over and over and
expecting different results."  -- assortedly attributed to Albert
Einstein, Benjamin Franklin, Rita Mae Brown, and Rudyard Kipling

In response to

  • Tuning 8.3 at 2008-02-25 15:47:37 from Roberts, Jon

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2008-02-25 20:05:24
Subject: Re: 8.3 / 8.2.6 restore comparison
Previous:From: Mathias HasselmannDate: 2008-02-25 19:40:50
Subject: Re: [PATCHES] Avahi support for Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group