Re: Less-silly selectivity for JSONB matching operators

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Less-silly selectivity for JSONB matching operators
Date: 2020-03-31 16:20:32
Message-ID: 9233.1585671632@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexey Bashtanov <bashtanov(at)imap(dot)cc> writes:
> The only little thing I can think of is hardcoding it as 2 * DEFAULT_EQ_SEL.
> While I don't have any arguments against the value itself I think it
> should be configurable independently.
> Sadly DEFAULT_MATCH_SEL name is already taken for text patterns.
> Not sure if it's a reason to rename all the stuff.

Yeah, I was going to invent a symbol till I noticed that DEFAULT_MATCH_SEL
was already taken :-(.

There are only about half a dozen uses of that in-core, so maybe we could
get away with renaming that one, but on the whole I'd rather leave it
alone in case some extension is using it. So that leaves us with needing
to find a better name for this new one. Any ideas?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Bashtanov 2020-03-31 16:26:14 Re: Less-silly selectivity for JSONB matching operators
Previous Message Alexey Bashtanov 2020-03-31 16:08:26 Re: Less-silly selectivity for JSONB matching operators