Re: Best way to index IP data?

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Best way to index IP data?
Date: 2008-01-12 06:00:48
Message-ID: 20080112010048.27678be8.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 11 Jan 2008 21:56:38 -0500 (EST)
Greg Smith <gsmith(at)gregsmith(dot)com> wrote:
> On Fri, 11 Jan 2008, Steve Atkins wrote:
>
> > You may well need netmasks to configure your interface, but there's
> > absolutely no need for them to identify an IP endpoint, which is all you
> > need to identify the destination the packet is going to, and that is the
> > most common use of IP addresses.
>
> Technically you can't ever send a packet unless you know both the endpoint
> and your local netmask. As the sender, you're obligated to determine if
> the destination is on your local LAN (in which case you send it there) or
> if it goes to the gateway. That's similar to a routing decision, but it's
> not quite--if you don't have to look in a routing table, it's not actually
> part of routing.

Not sure what your point is here. Sure, you need the netmask but not
of every IP address you send to, only for the IP/network that you are
on. That's a grand total of one netmask per interface that you need to
know. And you don't store it in your database.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message david 2008-01-12 11:17:31 Re: Best way to index IP data?
Previous Message Tom Lane 2008-01-12 05:44:14 Re: Simple select, but takes long time