Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to index IP data? - Mailing list pgsql-performance

From Michael Stone
Subject Re: Best way to index IP data?
Date
Msg-id 20080112003600.GA5294@mathom.us
Whole thread Raw
In response to Re: Best way to index IP data?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Best way to index IP data?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: Best way to index IP data?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Best way to index IP data?