How up to date are the statistics for the tables in question?
What value do you have for effective cache size?
My guess would be that planner thinks the method it is using is right
either for its current row number estimations, or the amount of memory
it thinks it has to play with.
-Origina
iate stats
target, and then explaining the query again to see if it's more
accurate.
Cheers
-Original Message-
From: Vincent de Phily [mailto:vincent.deph...@mobile-devices.fr]
Sent: 08 July 2011 10:20
To: French, Martin
Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.
