NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit77e2906

committed

Create an SP-GiST opclass for inet/cidr.

This seems to offer significantly better search performance than theexisting GiST opclass for inet/cidr, at least on data with a wide mixof network mask lengths. (That may suggest that the data splittingheuristics in the GiST opclass could be improved.)Emre Hasegeli, with mostly-cosmetic adjustments by meDiscussion: <CAE2gYzxtth9qatW_OAqdOjykS0bxq7AYHLuyAQLPgT7H9ZU0Cw@mail.gmail.com>

1 parent0fda682 commit77e2906Copy full SHA for 77e2906

File tree

13 files changed

+951

-3

lines changed

doc/src/sgml
- spgist.sgml
src
- backend/utils/adt
  - Makefile
  - network_spgist.c
- include
  - catalog
  - utils
    - inet.h
- test/regress
  - expected
    - inet.out
    - opr_sanity.out
  - sql
    - inet.sql

13 files changed

+951

-3

lines changed

`‎doc/src/sgml/spgist.sgml`

Lines changed: 17 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -145,6 +145,23 @@`
`145`	`145`	`<literal>~>~</>`
`146`	`146`	`</entry>`
`147`	`147`	`</row>`
	`148`	`+ <row>`
	`149`	`+ <entry><literal>inet_ops</></entry>`
	`150`	`+ <entry><type>inet</>, <type>cidr</></entry>`
	`151`	`+ <entry>`
	`152`	`+ <literal>&&</>`
	`153`	`+ <literal>>></>`
	`154`	`+ <literal>>>=</>`
	`155`	`+ <literal>></>`
	`156`	`+ <literal>>=</>`
	`157`	`+ <literal><></>`
	`158`	`+ <literal><<</>`
	`159`	`+ <literal><<=</>`
	`160`	`+ <literal><</>`
	`161`	`+ <literal><=</>`
	`162`	`+ <literal>=</>`
	`163`	`+ </entry>`
	`164`	`+ </row>`
`148`	`165`	`</tbody>`
`149`	`166`	`</tgroup>`
`150`	`167`	`</table>`

`‎src/backend/utils/adt/Makefile`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -17,7 +17,7 @@ OBJS = acl.o amutils.o arrayfuncs.o array_expanded.o array_selfuncs.o \`
`17`	`17`	`geo_ops.o geo_selfuncs.o geo_spgist.o inet_cidr_ntop.o inet_net_pton.o\`
`18`	`18`	`int.o int8.o json.o jsonb.o jsonb_gin.o jsonb_op.o jsonb_util.o\`
`19`	`19`	`jsonfuncs.o like.o lockfuncs.o mac.o misc.o nabstime.o name.o\`
`20`		`-network.o network_gist.o network_selfuncs.o\`
	`20`	`+network.o network_gist.o network_selfuncs.onetwork_spgist.o\`
`21`	`21`	`numeric.o numutils.o oid.o oracle_compat.o\`
`22`	`22`	`orderedsetaggs.o pg_locale.o pg_lsn.o pg_upgrade_support.o\`
`23`	`23`	`pgstatfuncs.o\`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit77e2906

File tree

13 files changed

13 files changed

`‎doc/src/sgml/spgist.sgml`

`‎src/backend/utils/adt/Makefile`

0 commit comments