asif ali a écrit :
Arnaud, Have you run "ANALYZE" on the table after creating index?
Yes, I have !
Also make sure that "#effective_cache_size" is set properly. A higher value makes it more likely to use index scans.
It is set to 50.000. I thought this would be enough, and maybe too much ! Thanks for your advice ! -- Arnaud
