Re: Less-silly selectivity for JSONB matching operators

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Less-silly selectivity for JSONB matching operators
Date: 2020-03-31 15:55:13
Message-ID: 8fcbdcc5-cbed-f96f-7ed4-f34d1bd1a205@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tom,

The patches look entirely reasonable to me.
The second one needs to be rebased.

I like the idea of stubbing matchjoinsel for now,
as well as being careful with operators that may correlate with sort
orderings.

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.

Best, Alex

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Bashtanov 2020-03-31 16:08:26 Re: Less-silly selectivity for JSONB matching operators
Previous Message Tom Lane 2020-03-31 15:47:30 Re: fix for BUG #3720: wrong results at using ltree