Re: Best way to index IP data? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Best way to index IP data?
Date
Msg-id 13179.1200064791@sss.pgh.pa.us
Whole thread Raw
In response to Re: Best way to index IP data?  (Pomarede Nicolas <npomarede@corp.free.fr>)
Responses Re: Best way to index IP data?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Best way to index IP data?  (Pomarede Nicolas <npomarede@corp.free.fr>)
Re: Best way to index IP data?  (Steve Atkins <steve@blighty.com>)
Re: Best way to index IP data?  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
Pomarede Nicolas <npomarede@corp.free.fr> writes:
> As ip4r seems to work very well with postgresql, is there a possibility to
> see it merged in postgresql, to have a native 4 bytes IPv4 address date
> type ?

Given that the world is going to IPv6 in a few years whether you like it
or not, that seems pretty darn short-sighted to me.

What would make sense IMHO is to adapt the improved indexing support in
ip4r to work on the native inet/cidr types.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Next
From: Andrew Sullivan
Date:
Subject: Re: Best way to index IP data?