pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Foster <martin@ethereal-realms.org>
To: Jan Wieck <JanWieck@Yahoo.com>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Performance Bottleneck
Date: Sun, 08 Aug 2004 01:29:16 -0400
Message-ID: <4115BA2C.3000900@ethereal-realms.org> (raw)
In-Reply-To: <4114E54C.7040200@Yahoo.com>
References: <ktQPc.23297$yT2.16983@clgrps13>
	<4114E54C.7040200@Yahoo.com>

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





view thread (38+ messages)  latest in thread

Message-ID: <4115BA2C.3000900@ethereal-realms.org>
Permalink:  ../4115BA2C.3000900@ethereal-realms.org/
Also on:    postgresql.org/message-id/4115BA2C.3000900@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, JanWieck@Yahoo.com
  Subject: Re: Performance Bottleneck
  In-Reply-To: <4115BA2C.3000900@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