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.