From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Best way to index IP data?
Date: Fri, 11 Jan 2008 18:00:55 -0500
Message-ID: <20080111230055.GB7618@crankycanuck.ca> (raw)
In-Reply-To: <1259C7B1-C948-4326-B827-849C64B61A16@blighty.com>
References: <36e682920801101541o7626bbddj428617144240c554@mail.gmail.com>
<Pine.LNX.4.64.0801111025390.30762@localhost>
<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>
On Fri, Jan 11, 2008 at 02:38:27PM -0800, Steve Atkins wrote:
> I don't think there's ambiguity about what an dotted-quad without a
> netmask
> means, and hasn't been for a long time. Am I missing something?
Well, maybe. The problem is actually that, without a netmask under CIDR,
the address alone isn't really enough. You have to have a netmask to get
the packets to the destination. As it happens, we have some nice
conventions, defined in the RFCs, for how to interpret hosts with no
netmask; note though that some of those are only for humans. Or, to put it
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). I'm not suggesting that's wrong,
but I can see the "correctness" argument that someone might have made to get
to the datatype as it exists. I think calling it "needless bloat" is just
holding it to the wrong criteria.
If you look at the binary wire data, that netmask is always represented in
some sense. It can sometimes be more compact than the general-purpose data
type, though, no question. This is why somewhere in this thread someone
talked about optimisation: there certainly are ways to make these things
more compact.
A
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Best way to index IP data?
In-Reply-To: <20080111230055.GB7618@crankycanuck.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox