From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Martin Foster <martin(at)ethereal-realms(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Performance Bottleneck |
Date: | 2004-08-07 14:21:00 |
Message-ID: | 4114E54C.7040200@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Foster | 2004-08-08 05:14:32 | Re: Performance Bottleneck |
Previous Message | Christopher Kings-Lynne | 2004-08-07 10:49:50 | Re: Performance Bottleneck |