On Mon, Feb 29, 2016 at 3:02 PM, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
>
> Perhaps I'm not being clear. Index 1 has field a and is used in the join no
> matter how small I set effective_cache_size (even 32mb). Index 2 has fields
> a,b but will not be used at ecs of 3gb, 6gb, whatever up til 8gb, when it's
> suddenly used.
>
> For the variation in size of the two indexes (say 20%?) that just doesn't
> add up.
What version of PostgreSQL are you using? Any chance you can share a
data-generator which reproduces this problem?
Cheers,
Jeff