Обсуждение: pgsql: Add sort support routine for the inet data type.

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

Peter Geoghegan <pg@bowt.ie> writes:
> Add sort support routine for the inet data type.

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

[ squint ... ]  Presumably there should have been a catversion bump
here?

(Probably not too important since I just pushed a bump an hour
or so earlier, but still.)

            regards, tom lane

On Thu, Aug 1, 2019 at 12:17 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> (Probably not too important since I just pushed a bump an hour
> or so earlier, but still.)

My mistake. I'll push a catversion bump commit shortly.

-- 
Peter Geoghegan