Re: Less-silly selectivity for JSONB matching operators

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexey Bashtanov <bashtanov@imap.cc>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2020-03-31T16:29:25Z
Lists: pgsql-hackers
Alexey Bashtanov <bashtanov@imap.cc> writes:
>> So that leaves us with needing
>> to find a better name for this new one.  Any ideas?

> I'm thinking of something wide like
> opersel, operjoinsel, DEFAULT_OPER_SEL
> or maybe even
> genericsel, genericjoinsel, DEFAULT_GENERIC_SEL

Seems a little *too* generic :-(

I was wondering about DEFAULT_MATCHING_SEL.  The difference in purpose
from DEFAULT_MATCH_SEL wouldn't be too obvious, but then it probably
wouldn't be anyway.

			regards, tom lane



Commits

  1. Improve selectivity estimation for assorted match-style operators.

  2. Implement operator class parameters