Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CFF0D2E3A46 for ; Fri, 11 Jan 2008 20:12:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 94193-01 for ; Fri, 11 Jan 2008 20:11:54 -0400 (AST) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id 7F3012E3A7B for ; Fri, 11 Jan 2008 20:11:58 -0400 (AST) Received: from osgiliath.mathom.us ([71.178.47.70]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JUI00LLV8JG3FX5@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Fri, 11 Jan 2008 18:11:40 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 509361F81D; Fri, 11 Jan 2008 19:11:39 -0500 (EST) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 5apI+WSpAsS7; Fri, 11 Jan 2008 19:11:38 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 188A71F80E; Fri, 11 Jan 2008 19:11:38 -0500 (EST) Date: Fri, 11 Jan 2008 19:11:37 -0500 From: Michael Stone Subject: Re: Best way to index IP data? In-reply-to: <20080111230055.GB7618@crankycanuck.ca> To: Andrew Sullivan , pgsql-performance@postgresql.org Mail-followup-to: Andrew Sullivan , pgsql-performance@postgresql.org Message-id: <20080112001135.GY5294@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Virus-Scanned: Debian amavisd-new at mathom.us X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 References: <13179.1200064791@sss.pgh.pa.us> <20080111162747.GT5294@mathom.us> <24044.1200082058@sss.pgh.pa.us> <20080111212703.GU5294@mathom.us> <20080111213710.GD8260@alvh.no-ip.org> <20080111220235.GX5294@mathom.us> <20080111222403.GA7527@crankycanuck.ca> <1259C7B1-C948-4326-B827-849C64B61A16@blighty.com> <20080111230055.GB7618@crankycanuck.ca> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/88 X-Sequence-Number: 28327 On Fri, Jan 11, 2008 at 06:00:55PM -0500, Andrew Sullivan wrote: >another way, without context, a dotted-quad is insufficient on its own. >What you're really arguing is that the context ought to be storable >somewhere else (maybe in a human's brain) Or, say, in a database schema, where you say "this column contains host IPs"? Are you suggesting that the IP associated with the host can somehow be ambiguous? IMO, the only ambiguity is that the type is defined as "network or host". Mike Stone