Ben <bench@xxxxxxxxxxxxxxx> 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
