pgsql: Add sort support routine for the inet data type. - Mailing list pgsql-committers

From Peter Geoghegan
Subject pgsql: Add sort support routine for the inet data type.
Date
Msg-id E1htE2I-0008UY-Ez@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Add sort support routine for the inet data type.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/71dcd7438664d81235c72337cbbbfa780f7a0630

Modified Files
--------------
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(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Add an isolation test to exercise parallel-worker deadlockresol
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Add sort support routine for the inet data type.