pgsql: Add sort support routine for the inet data type.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add sort support routine for the inet data type.
Date: 2019-08-01 16:34:38
Message-ID: E1htE2I-0008UY-Ez@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(+)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2019-08-01 17:19:51 Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)
Previous Message Shay Rojansky 2019-08-01 16:33:52 Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)