Create an SP-GiST opclass for inet/cidr.
Tom Lane <tgl@sss.pgh.pa.us>
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>
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/spgist.sgml | modified | +17 −0 |
| src/backend/utils/adt/Makefile | modified | +1 −1 |
| src/backend/utils/adt/network_spgist.c | added | +708 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_amop.h | modified | +15 −0 |
| src/include/catalog/pg_amproc.h | modified | +5 −0 |
| src/include/catalog/pg_opclass.h | modified | +1 −0 |
| src/include/catalog/pg_opfamily.h | modified | +1 −0 |
| src/include/catalog/pg_proc.h | modified | +12 −0 |
| src/include/utils/inet.h | modified | +9 −0 |
| src/test/regress/expected/inet.out | modified | +148 −0 |
| src/test/regress/expected/opr_sanity.out | modified | +10 −1 |
| src/test/regress/sql/inet.sql | modified | +23 −0 |