pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: D'Arcy J.M. Cain <darcy@druid.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best way to index IP data?
Date: Fri, 11 Jan 2008 15:19:35 -0500
Message-ID: <20080111151935.40c8d2fd.darcy@druid.net> (raw)
In-Reply-To: <24044.1200082058@sss.pgh.pa.us>
References: <200801101614.54729.kevin@kevinkempterllc.com>
	<DA6DE53A-2F69-46F3-8C96-B341ADCDDFAF@blighty.com>
	<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>

On Fri, 11 Jan 2008 15:07:38 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Michael Stone <mstone+postgres@mathom.us> writes:
> > Well, a native IPv6 type would also be nice; inet is ridiculously 
> > bloated for both IPv4 *and* IPv6. 
> 
> Nonsense.  3 bytes overhead on a 16-byte address is not "ridiculously
> bloated", especially if you want a netmask with it.

Besides, there are many cases where you want to track both ipv4 and
ipv6 for the same purpose and requiring two different fields would be
less than ideal.

-- 
D'Arcy J.M. Cain <darcy@druid.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.



view thread (42+ messages)  latest in thread

Message-ID: <20080111151935.40c8d2fd.darcy@druid.net>
Permalink:  ../20080111151935.40c8d2fd.darcy@druid.net/
Also on:    postgresql.org/message-id/20080111151935.40c8d2fd.darcy@druid.net

 · 

reply
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: darcy@druid.net, tgl@sss.pgh.pa.us, mstone+postgres@mathom.us
  Subject: Re: Best way to index IP data?
  In-Reply-To: <20080111151935.40c8d2fd.darcy@druid.net>

* 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