diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-08-23 15:16:21 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-08-23 15:16:30 -0400 |
| commit | 77e2906821e2aec3c0807866a84c2934feeac8be (patch) | |
| tree | acf0ecb7a26ad879b2001db3621e05c77dea94d1 /doc/src | |
| parent | 0fda682e542c9acd368588e50a1993fecd3b73e2 (diff) | |
Create an SP-GiST opclass for inet/cidr.
This seems to offer significantly better search performance than the
existing GiST opclass for inet/cidr, at least on data with a wide mix
of network mask lengths. (That may suggest that the data splitting
heuristics in the GiST opclass could be improved.)
Emre Hasegeli, with mostly-cosmetic adjustments by me
Discussion: <CAE2gYzxtth9qatW_OAqdOjykS0bxq7AYHLuyAQLPgT7H9ZU0Cw@mail.gmail.com>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/spgist.sgml | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/doc/src/sgml/spgist.sgml b/doc/src/sgml/spgist.sgml index dfa62adb557..d60aa23f33b 100644 --- a/doc/src/sgml/spgist.sgml +++ b/doc/src/sgml/spgist.sgml @@ -145,6 +145,23 @@ <literal>~>~</> </entry> </row> + <row> + <entry><literal>inet_ops</></entry> + <entry><type>inet</>, <type>cidr</></entry> + <entry> + <literal>&&</> + <literal>>></> + <literal>>>=</> + <literal>></> + <literal>>=</> + <literal><></> + <literal><<</> + <literal><<=</> + <literal><</> + <literal><=</> + <literal>=</> + </entry> + </row> </tbody> </tgroup> </table> |