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

From: daniel(dot)heden(at)sweco(dot)se
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.
Date: 2012-10-15 10:55:54
Message-ID: E1TNiKw-0004uY-Nu@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7602
Logged by: Daniel Hedén
Email address: daniel(dot)heden(at)sweco(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message lst_hoe02 2012-10-15 11:30:09 Re: WebSphere Application Server support for postgres
Previous Message Heikki Linnakangas 2012-10-15 10:13:01 Re: BUG #7534: walreceiver takes long time to detect n/w breakdown