git.postgresql.org Git - users/gsingh/postgres.git/commit

projects / users / gsingh / postgres.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: 0fda682) | patch

author	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 23 Aug 2016 19:16:21 +0000 (15:16 -0400)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 23 Aug 2016 19:16:30 +0000 (15:16 -0400)
commit	77e2906821e2aec3c0807866a84c2934feeac8be
tree	acf0ecb7a26ad879b2001db3621e05c77dea94d1	tree
parent	0fda682e542c9acd368588e50a1993fecd3b73e2	commit \| 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>

13 files changed:

doc/src/sgml/spgist.sgml		diff \| blob \| blame \| history
src/backend/utils/adt/Makefile		diff \| blob \| blame \| history
src/backend/utils/adt/network_spgist.c	[new file with mode: 0644]	blob
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/pg_amop.h		diff \| blob \| blame \| history
src/include/catalog/pg_amproc.h		diff \| blob \| blame \| history
src/include/catalog/pg_opclass.h		diff \| blob \| blame \| history
src/include/catalog/pg_opfamily.h		diff \| blob \| blame \| history
src/include/catalog/pg_proc.h		diff \| blob \| blame \| history
src/include/utils/inet.h		diff \| blob \| blame \| history
src/test/regress/expected/inet.out		diff \| blob \| blame \| history
src/test/regress/expected/opr_sanity.out		diff \| blob \| blame \| history
src/test/regress/sql/inet.sql		diff \| blob \| blame \| history

Postgres clone for personal branches