Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with performance problems - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Help with performance problems
Date
Msg-id 200404230942.48290.josh@agliodbs.com
Whole thread Raw
In response to Help with performance problems  ("Chris Hoover" <revoohc@sermonaudio.com>)
Responses Re: Help with performance problems
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Looking for ideas on how to speed up warehouse loading
Next
From: "Chris Hoover"
Date:
Subject: Re: Help with performance problems