Re: index scan backward plan question

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: index scan backward plan question
Дата
Msg-id 1142981278.10422.33.camel@localhost.localdomain
обсуждение исходный текст
Ответ на index scan backward plan question  (Kevin Murphy <murphy@genome.chop.edu>)
Ответы Re: index scan backward plan question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: index scan backward plan question  (Kevin Murphy <murphy@genome.chop.edu>)
Список pgsql-general
On Tue, 2006-03-21 at 16:58 -0500, Kevin Murphy wrote:
> I have a table for which PG 8.3 is guessing wrong about a plan when the
> result set gets large.

There is no such thing as "PG 8.3".

>    ->  Index Scan Backward using merged_weight_date_idx on merged
> (cost=0.00..31295593.98 rows=141839 width=229) (actual
> time=3.888..10380.783 rows=500 loops=1)

The mis-estimation of the result set of the index scan is clearly a
problem -- have you run ANALYZE recently? Try re-running ANALYZE and
retrying EXPLAIN ANALYZE.

Otherwise, please provide the queries that trigger the problem and the
relevant schema definitions.

-Neil



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

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: Postgresql won't run after upgrade to fc5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: index scan backward plan question