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 7E0FF5E46C0 for ; Sun, 8 Aug 2004 02:29:23 -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 44689-02 for ; Sun, 8 Aug 2004 05:29:19 +0000 (GMT) Received: from fep2.cogeco.net (smtp.cogeco.net [216.221.81.25]) by svr1.postgresql.org (Postfix) with ESMTP id 3FB5C5E46D1 for ; Sun, 8 Aug 2004 02:29:19 -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 C0FFD25F6; Sun, 8 Aug 2004 01:29:18 -0400 (EDT) Message-ID: <4115BA2C.3000900@ethereal-realms.org> Date: Sun, 08 Aug 2004 01:29:16 -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: Jan Wieck , PostgreSQL Performance Subject: Re: Performance Bottleneck References: <4114E54C.7040200@Yahoo.com> In-Reply-To: <4114E54C.7040200@Yahoo.com> 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/98 X-Sequence-Number: 7734 Jan Wieck wrote: > On 8/3/2004 2:05 PM, Martin Foster wrote: > >> I run a Perl/CGI driven website that makes extensive use of PostgreSQL >> (7.4.3) for everything from user information to formatting and display >> of specific sections of the site. The server itself, is a dual >> processor AMD Opteron 1.4Ghz w/ 2GB Ram and 2 x 120GB hard drives >> mirrored for redundancy running under FreeBSD 5.2.1 (AMD64). >> >> Recently loads on the site have increased during peak hours to the >> point of showing considerable loss in performance. This can be >> observed when connections move from the 120 concurrent connections to >> PostgreSQL to roughly 175 or more. Essentially, the machine seems >> to struggle to keep up with continual requests and slows down >> respectively as resources are tied down. > > > Have you taken a look at pgpool? I know, it sounds silly to *reduce* the > number of DB connections through a connection pool, but it can help. > > > Jan > 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. Anyone had any experience with both Apache::DBI and pgpool? For my needs they seem to do essentially the same thing, simply that one is invisible to the code while the other requires adding the complexity of a proxy. Martin Foster Creator/Designer Ethereal Realms martin@ethereal-realms.org