Re: Performance Bottleneck - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Performance Bottleneck
Date
Msg-id 410FDEEC.90901@commandprompt.com
Whole thread Raw
In response to Performance Bottleneck  (Martin Foster <martin@ethereal-realms.org>)
List pgsql-performance
Hello,

It sounds to me like you are IO bound. 2x120GB hard drives just isn't
going to cut it with that many connections (as a general rule). Are you
swapping ?

Sincerely,

Joshua D. Drake





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).
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-performance by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: Performance Bottleneck
Next
From: Gaetano Mendola
Date:
Subject: Re: NOT IN query takes forever