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
indexscans.
It is set to 50.000. I thought this would be enough, and maybe too much !
Thanks for your advice !
--
Arnaud