Horton

Add sort support routine for the inet data type.

Peter Geoghegan <pg@bowt.ie>

View on postgr.es
Commit: 71dcd7438664d81235c72337cbbbfa780f7a0630
Author: Peter Geoghegan <pg@bowt.ie>
Date: 2019-08-01T16:34:14Z
Releases: 13.0 
Add sort support routine for the inet data type.

Add sort support for inet, including support for abbreviated keys.
Testing has shown that this reduces the time taken to sort medium to
large inet/cidr inputs by ~50-60% in realistic cases.

Author: Brandur Leach
Reviewed-By: Peter Geoghegan, Edmund Horner
Discussion: https://postgr.es/m/CABR_9B-PQ8o2MZNJ88wo6r-NxW2EFG70M96Wmcgf99G6HUQ3sw@mail.gmail.com

Files

PathChange+/−
src/backend/utils/adt/network.c modified +399 −0
src/include/catalog/pg_amproc.dat modified +3 −0
src/include/catalog/pg_proc.dat modified +3 −0
src/test/regress/expected/inet.out modified +189 −0
src/test/regress/sql/inet.sql modified +95 −0

Discussion