Re: Best way to index IP data?

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Best way to index IP data?
Date: 2008-01-12 00:36:02
Message-ID: 20080112003600.GA5294@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 11, 2008 at 07:19:10PM -0500, Tom Lane wrote:
>It was correct, but not as of 8.3. Considering you could save a whole
>one byte by not storing the netmask

Hmm. One for the netmask, plus the other two mystery bytes. :-) A byte
here and a byte there is fine. 20% of a few billion IPs does start to
add up.

Mike Stone

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-12 00:43:18 Re: Best way to index IP data?
Previous Message Michael Stone 2008-01-12 00:21:29 Re: Best way to index IP data?