Re: Quad Opteron stuck in the mud - Mailing list pgsql-performance

From Stephen Frost
Subject Re: Quad Opteron stuck in the mud
Date
Msg-id 20050713201715.GI24207@ns.snowman.net
Whole thread Raw
In response to Re: Quad Opteron stuck in the mud  (Dan Harris <fbsd@drivefaster.net>)
Responses Re: Quad Opteron stuck in the mud
List pgsql-performance
* Dan Harris (fbsd@drivefaster.net) wrote:
> On Jul 13, 2005, at 1:11 PM, John A Meinel wrote:
> >I might be wrong, but there may be something much more substantially
> >wrong than slow i/o.
>
> Yes, I'm afraid of that too.  I just don't know what tools I should
> use to figure that out.  I have some 20 other databases on this
> system, same schema but varying sizes, and the small ones perform
> very well.  It feels like there is an O(n) increase in wait time that
> has recently become very noticeable on the largest of them.

Could you come up w/ a test case that others could reproduce where
explain isn't returning?  I think that would be very useful towards
solving at least that issue...

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Re: Quad Opteron stuck in the mud
Next
From: Alvaro Herrera
Date:
Subject: Re: Quad Opteron stuck in the mud