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

From John A Meinel
Subject Re: Quad Opteron stuck in the mud
Date
Msg-id 42D56772.6020408@arbash-meinel.com
Whole thread Raw
In response to Quad Opteron stuck in the mud  (Dan Harris <fbsd@drivefaster.net>)
Responses Re: Quad Opteron stuck in the mud
List pgsql-performance
Dan Harris wrote:
> Gurus,
>

 > even the  explain never
> finishes when I try that.

Just a short bit. If "EXPLAIN SELECT" doesn't return, there seems to be
a very serious problem. Because I think EXPLAIN doesn't actually run the
query, just has the query planner run. And the query planner shouldn't
ever get heavily stuck.

I might be wrong, but there may be something much more substantially
wrong than slow i/o.
John
=:->

Attachment

pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Re: Quad Opteron stuck in the mud
Next
From: Dennis
Date:
Subject: performance problems ... 100 cpu utilization