Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2631F2E3D5D for ; Fri, 11 Jan 2008 11:38:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16760-01 for ; Fri, 11 Jan 2008 11:37:51 -0400 (AST) Received: from main1.mycybernet.net (main1.mycybernet.net [209.222.63.135]) by postgresql.org (Postfix) with ESMTP id 5ACF32E3C70 for ; Fri, 11 Jan 2008 11:38:00 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main1.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JDLwx-0007q9-6H for pgsql-performance@postgresql.org; Fri, 11 Jan 2008 10:37:39 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 913F04FFE2; Fri, 11 Jan 2008 10:37:34 -0500 (EST) Date: Fri, 11 Jan 2008 10:37:34 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Best way to index IP data? Message-ID: <20080111153734.GD5963@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <200801101614.54729.kevin@kevinkempterllc.com> <36e682920801101541o7626bbddj428617144240c554@mail.gmail.com> <13179.1200064791@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <13179.1200064791@sss.pgh.pa.us> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/67 X-Sequence-Number: 28306 On Fri, Jan 11, 2008 at 10:19:51AM -0500, Tom Lane wrote: > 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. Indeed. Even ARIN has finally started to tell people that IPv4 is running out. There are currently significant deployments of IPv6 in the Asia-Pacific region. And it appears that Comcast is planning to move to IPv6 for its own network deployment, which may mean that many U.S. homes will have native v6 in the near future (the upshot of their plans aren't actually clear to me yet, but if you're interested in some of what they're telling people they're doing, look for Alain Durand's presentation to the v6ops working group at the last IETF meeting). > What would make sense IMHO is to adapt the improved indexing support in > ip4r to work on the native inet/cidr types. This seems like a good idea to me.