pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Foster <martin@ethereal-realms.org>
To: Jeff <threshar@torgo.978.org>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Performance Bottleneck
Date: Sun, 08 Aug 2004 11:49:10 -0400
Message-ID: <41164B76.1030603@ethereal-realms.org> (raw)
In-Reply-To: <ED5E071A-E933-11D8-A672-000D9366F0C4@torgo.978.org>
References: <ktQPc.23297$yT2.16983@clgrps13>
	<4114E54C.7040200@Yahoo.com>
	<4115BA2C.3000900@ethereal-realms.org>
	<ED5E071A-E933-11D8-A672-000D9366F0C4@torgo.978.org>

Jeff wrote:
> 
> On Aug 8, 2004, at 1:29 AM, Martin Foster wrote:
> 
>> I am currently making use of Apache::DBI which overrides the 
>> DBI::disconnect call and keeps a pool of active connections for use 
>> when need be.   Since it offloads the pooling to the webserver, it 
>> seems more advantageous then pgpool which while being able to run on a 
>> external system is not adding another layer of complexity.
>>
> 
> Apache::DBI is not the same sort of a pool as pgpool.  DB connections 
> are not shared among all your apache children (A common misconception). 
>  So if you have 300 apache kids you can have have 300 db connections.  
> With pgpool connections are  shared among all of them so even though you 
> have 300 kids you only have say 32 db connections.
> 

Seems that you are right, never noticed that from the documentation 
before.   I always assumed it had something to do with the long 
lasting/persistent scripts that would remain in transactions for 
extended periods of time.

Here is an odd question.   While the server run 7.4.x, the client 
connects with 7.3.x.  Would this in itself make a difference in 
performance as the protocols are different?   At least based from 
pgpool's documentation.

	Martin Foster
	Creator/Designer Ethereal Realms
	martin@ethereal-realms.org





view thread (38+ messages)  latest in thread

Message-ID: <41164B76.1030603@ethereal-realms.org>
Permalink:  ../41164B76.1030603@ethereal-realms.org/
Also on:    postgresql.org/message-id/41164B76.1030603@ethereal-realms.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: martin@ethereal-realms.org, threshar@torgo.978.org
  Subject: Re: Performance Bottleneck
  In-Reply-To: <41164B76.1030603@ethereal-realms.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox