Re: How to track down inconsistent performance?

Поиск
Список
Период
Сортировка
От Ron Snyder
Тема Re: How to track down inconsistent performance?
Дата
Msg-id F888C30C3021D411B9DA00B0D0209BE8026E303A@cvo-exchange.cvo.roguewave.com
обсуждение исходный текст
Ответ на How to track down inconsistent performance?  (Ron Snyder <snyder@roguewave.com>)
Ответы Re: How to track down inconsistent performance?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> affect that).  I would think that a seqscan would be faster for this.
> I would definitely think that the planner would think so --- are you
> forcing enable_seqscan off?

Forgot to answer this-- no, we're not forcing it off.  Maybe we need to
force it to use a seqscan for this query?


> Since you're evidently running 7.2, I'd ask for EXPLAIN ANALYZE rather

We are still running 7.2 on this database-- we're in the middle of
acceptance testing for the 7.2.1 upgrade.

-ron


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

Предыдущее
От: Ron Snyder
Дата:
Сообщение: Re: How to track down inconsistent performance?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: JOINing subselects in FROM?