Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Дата
Msg-id 29616.1133795501@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0  ("Markus Wollny" <Markus.Wollny@computec.de>)
Ответы Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-performance
"Markus Wollny" <Markus.Wollny@computec.de> writes:
>> Could we see the pg_stats row for answer.session_id in both
>> 8.0 and 8.1?

> Here you are:

> 8.1:
> Correlation        -0.0736492

> 8.0.3:
> Correlation        -0.237136

Interesting --- if the 8.1 database is a dump and restore of the 8.0,
you'd expect the physical ordering to be similar.  Why is 8.1 showing
a significantly lower correlation?  That has considerable impact on the
estimated cost of an indexscan (plain not bitmap), and so it might
explain why 8.1 is mistakenly avoiding the indexscan ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BLCKSZ
Следующее
От: "Markus Wollny"
Дата:
Сообщение: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0