Re: [GENERAL] Abnormal long SELECT query under postgresql 9.0.4

2011-06-08 Thread Radosław Smogura
Gaëtan Allart Wednesday 08 of June 2011 14:59:05 > Hi everyone, > > We've just moved our website database from pg 8.4 to pg 9.0 and we found > out a very long query (that wasn't that long under 8.4). > And I actually can't explain why it's taking so much timeŠ > > > > Here it is : > > EXPLAIN

[GENERAL] Abnormal long SELECT query under postgresql 9.0.4

2011-06-08 Thread Gaëtan Allart
Hi everyone, We've just moved our website database from pg 8.4 to pg 9.0 and we found out a very long query (that wasn't that long under 8.4). And I actually can't explain why it's taking so much timeŠ Here it is : EXPLAIN ANALYZE SELECT "articles_article"."id", "articles_article"."name", "ar