Re: [PERFORM] IP addresses, NetBlocks, and ASNs

2014-04-20 Thread Gary Warner
Steve, The "indexable IPv4 range" described on that pgfoundry site sounds like exactly what I've been trying to figure out. That said, I also agree with your approach of "lookup and store with each record at fetch time" for exactly the reason you give. If the location of that IP address chan

Re: [PERFORM] IP addresses, NetBlocks, and ASNs

2014-04-20 Thread Steve Atkins
On Apr 19, 2014, at 7:12 PM, Gary Warner wrote: > Does anyone have some good tricks for mapping IP addresses to ASN numbers in > very large volumes? > > This is probably more a "how would you approach this problem?" than "can you > help me tweak this query" > > I have a very large number of