Postgres Pro
Downloads
Home   >   mailing lists

BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0. - Mailing list pgsql-bugs

From daniel.heden@sweco.se
Subject BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.
Date
Msg-id E1TNiKw-0004uY-Nu@wrigleys.postgresql.org
Whole thread Raw
Responses 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>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Michał Hankiewicz
Date:
Subject: Re: BUG #7600: Database crash with data corruption
Next
From: devenmthaker@gmail.com
Date:
Subject: BUG #7603: Application takes long time to fetch data from postgresql database