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 11679.1133454886@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>)
Список pgsql-performance
"Markus Wollny" <Markus.Wollny@computec.de> writes:
>> Once you're not under deadline,
>> I'd like to investigate more closely to find out why 8.1 does
>> worse than 8.0 here.

> Please tell me what I can do to help in clearing up this issue, I'd be
> very happy to help!

The first thing to do is get 8.0's EXPLAIN ANALYZE for the same query.
After we see how that differs from 8.1, we'll know what the next
question should be ...

            regards, tom lane

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

Предыдущее
От: Guido Neitzer
Дата:
Сообщение: Re: 15,000 tables
Следующее
От: Michael Riess
Дата:
Сообщение: Re: 15,000 tables