On Mon, Feb 29, 2016 at 3:02 PM, Geoff Winkless <pgsqladmin@xxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
