On Mon, Feb 22, 2016, at 02:49 PM, Tom Lane wrote: > Seamus Abshere <seamus@xxxxxxxxxxx> writes: > > Inspired, I changed cpu_index_tuple_cost to 0.1 (default: 0.005). It "fixed" my problem by preventing the BitmapAnd. > > Is this dangerous? > > Use a gentle tap, man, don't swing the hammer with quite so much abandon. > I'd have tried doubling the setting to start with. Raising it 20X might > cause other queries to change behavior undesirably. Doubling it was enough :) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
