Re: Best way to index IP data?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pomarede Nicolas <npomarede(at)corp(dot)free(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Best way to index IP data?
Date: 2008-01-11 15:19:51
Message-ID: 13179.1200064791@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Pomarede Nicolas <npomarede(at)corp(dot)free(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2008-01-11 15:37:34 Re: Best way to index IP data?
Previous Message Tom Lane 2008-01-11 15:05:40 Re: Linux/PostgreSQL scalability issue - problem with 8 cores