Skip site navigation (1) Skip section navigation (2)

Re: Help with performance problems

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Cc: <revoohc(at)sermonaudio(dot)com>
Subject: Re: Help with performance problems
Date: 2004-04-23 16:42:48
Message-ID: 200404230942.48290.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Chris,

> I need some help.  I have 5 db servers running our database servers, and
> they all are having various degrees of performance problems.  The problems
> we are experiencing are:

I'mm confused.  You're saying "general slowness" but say that most queries run 
in under .01 seconds.   And you say "high loads" but the TOP snapshots you 
provide show servers with 2 CPUs idle.   

Are you sure you actually *have* a performance issue?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Chris HooverDate: 2004-04-23 17:16:03
Subject: Re: Help with performance problems
Previous:From: scott.marloweDate: 2004-04-23 16:25:01
Subject: Re: Looking for ideas on how to speed up warehouse loading

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group