Re: [PERFORM] Possible regression (slow query on 9.2/9.3 when compared to 9.1)

2013-12-29 Thread Tom Lane
Ronaldo Maia writes: > Recently I have tried to upgrade our postgres instalation from 9.1 to 9.3, > but one query in particular got extremelly slow. FWIW, this test case doesn't reproduce any problem for me --- I get identical plans and indistinguishable timings (about 450ms on my machine) from 9

[PERFORM] Possible regression (slow query on 9.2/9.3 when compared to 9.1)

2013-12-26 Thread Ronaldo Maia
Hello everybody. Recently I have tried to upgrade our postgres instalation from 9.1 to 9.3, but one query in particular got extremelly slow. The query is: EXPLAIN ANALYZE SELECT * FROM sellable JOIN product ON product.sellable_id = sellable.id LEFT JOIN storable ON storable.produc