Re: Efficiently searching for CIDRs containing an IP address

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Efficiently searching for CIDRs containing an IP address
Date: 2009-06-01 10:14:05
Message-ID: 4A23A9ED.9020503@roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alan McKay wrote:

> So is this not simply easier to implement with a library of functions
> to convert a string to binary and back?

The representation format has nothing to do with making a range search
efficiently use an index, though.

Regards,

David.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Justin Carrera 2009-06-01 13:28:39 ruby connect
Previous Message Alan McKay 2009-06-01 01:14:50 Re: Efficiently searching for CIDRs containing an IP address