X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 44C4D5E46C4 for ; Sun, 8 Aug 2004 12:49:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81193-07 for ; Sun, 8 Aug 2004 15:49:19 +0000 (GMT) Received: from fep2.cogeco.net (smtp.cogeco.net [216.221.81.25]) by svr1.postgresql.org (Postfix) with ESMTP id F05235E40BB for ; Sun, 8 Aug 2004 12:49:10 -0300 (ADT) Received: from [127.0.0.1] (d226-86-215.home.cgocable.net [24.226.86.215]) by fep2.cogeco.net (Postfix) with ESMTP id 1BC3B2515; Sun, 8 Aug 2004 11:49:17 -0400 (EDT) Message-ID: <41164B76.1030603@ethereal-realms.org> Date: Sun, 08 Aug 2004 11:49:10 -0400 From: Martin Foster Organization: Ethereal Realms User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-ca, en-gb, en-us, en MIME-Version: 1.0 To: Jeff , PostgreSQL Performance Subject: Re: Performance Bottleneck References: <4114E54C.7040200@Yahoo.com> <4115BA2C.3000900@ethereal-realms.org> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/104 X-Sequence-Number: 7740 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