Add sort support routine for the inet data type

Enterprise / PostgreSQL - Peter Geoghegan [bowt.ie] - 1 August 2019 16:34 EDT

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

71dcd74386 Add sort support routine for the inet data type.
src/backend/utils/adt/network.c | 399 +++++++++++++++++++++++++++++++++++++
src/include/catalog/pg_amproc.dat | 3 +
src/include/catalog/pg_proc.dat | 3 +
src/test/regress/expected/inet.out | 189 ++++++++++++++++++
src/test/regress/sql/inet.sql | 95 +++++++++
5 files changed, 689 insertions(+)

Upstream: git.postgresql.org


  • Share