Re: Quad Opteron stuck in the mud

Поиск
Список
Период
Сортировка
От John A Meinel
Тема Re: Quad Opteron stuck in the mud
Дата
Msg-id 42D56772.6020408@arbash-meinel.com
обсуждение исходный текст
Ответ на Quad Opteron stuck in the mud  (Dan Harris <fbsd@drivefaster.net>)
Ответы Re: Quad Opteron stuck in the mud  (Dan Harris <fbsd@drivefaster.net>)
Список 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
=:->

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dan Harris
Дата:
Сообщение: Re: Quad Opteron stuck in the mud
Следующее
От: Dennis
Дата:
Сообщение: performance problems ... 100 cpu utilization