Brian Herlihy <btherl(at)yahoo(dot)com(dot)au> writes:
> My options seem to be
> - Fudge the analysis results so that the selectivity estimate changes. I
> have tested reducing n_distinct, but this doesn't seem to help.
> - Combine the columns into one column, allowing postgres to calculate the
> combined selectivity.
> - Drop the (p2, p3) index. But I need this for other queries.
Have you considered reordering the pkey to be (p2,p3,p1) and then
dropping the (p2,p3) index?
regards, tom lane