Ben <bench(at)silentmedia(dot)com> writes:
> How can I get the planner to not expect so many rows to be returned?
Write an estimation function for the pg_trgm operator(s). (Send in a
patch if you do!) I see that % is using "contsel" which is only a stub,
and would likely be wrong for % even if it weren't.
> A possibly related question is: because pg_tgrm lets me set the
> matching threshold of the % operator, how does that affect the planner?
It hasn't a clue about that.
regards, tom lane