Re: Less-silly selectivity for JSONB matching operators - Mailing list pgsql-hackers

From Alexey Bashtanov
Subject Re: Less-silly selectivity for JSONB matching operators
Date
Msg-id 8fcbdcc5-cbed-f96f-7ed4-f34d1bd1a205@imap.cc
Whole thread Raw
In response to Re: Less-silly selectivity for JSONB matching operators  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Less-silly selectivity for JSONB matching operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: fix for BUG #3720: wrong results at using ltree
Next
From: Alexey Bashtanov
Date:
Subject: Re: Less-silly selectivity for JSONB matching operators