BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.

Поиск
Список
Период
Сортировка
От daniel.heden@sweco.se
Тема BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.
Дата
Msg-id E1TNiKw-0004uY-Nu@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      7602
Logged by:          Daniel Hed=C3=A9n
Email address:      daniel.heden@sweco.se
PostgreSQL version: 9.2.1
Operating system:   Windows 7 / Vista 64-Bit
Description:        =


Select with many joins against the same table is very slow compared to
9.2.0.
In my case 16 times, this query takes a second max on 9.2.0 but on 9.2.1 it
takes more than 30 minutes.

The database is the same in both cases and running analyze does not help.

On request i could send the SQL and a database backup.

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

Предыдущее
От: Michał Hankiewicz
Дата:
Сообщение: Re: BUG #7600: Database crash with data corruption
Следующее
От: devenmthaker@gmail.com
Дата:
Сообщение: BUG #7603: Application takes long time to fetch data from postgresql database