Re: Less-silly selectivity for JSONB matching operators

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

View thread View on postgr.es

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

To: Alexey Bashtanov <bashtanov@imap.cc>

Cc: pgsql-hackers@lists.postgresql.org

Date: 2020-03-31T17:53:37Z

Lists: pgsql-hackers

Attachments

0001-better-jsonb-selectivity-2.patch (text/x-diff) patch 0001
0002-better-contrib-selectivity-2.patch (text/x-diff) patch 0002

Renamed "matchsel" to "matchingsel" etc, added DEFAULT_MATCHING_SEL,
rebased over commit 911e70207.  Since that commit already created
new versions of the relevant contrib modules, I think we can just
redefine what those versions contain, rather than making yet-newer
versions.  (Of course, that assumes we're going to include this in
v13.)

			regards, tom lane

Commits

Improve selectivity estimation for assorted match-style operators.
- a80818605e54 13.0 landed
Implement operator class parameters
- 911e70207703 13.0 cited