Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 11 Jan 2008 19:36:02 -0500
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
- Follow-Ups:
- Re: Best way to index IP data?
- From: Joshua D. Drake
- Re: Best way to index IP data?
- References:
- Best way to index IP data?
- From: Kevin Kempter
- Re: Best way to index IP data?
- From: Steve Atkins
- Re: Best way to index IP data?
- From: Jonah H. Harris
- Re: Best way to index IP data?
- From: Pomarede Nicolas
- Re: Best way to index IP data?
- From: Tom Lane
- Re: Best way to index IP data?
- From: Michael Stone
- Re: Best way to index IP data?
- From: Tom Lane
- Re: Best way to index IP data?
- From: Michael Stone
- Re: Best way to index IP data?
- From: Tom Lane
- Best way to index IP data?
- Prev by Date: Re: Best way to index IP data?
- Next by Date: Re: Best way to index IP data?
- Previous by thread: Re: Best way to index IP data?
- Next by thread: Re: Best way to index IP data?
- Indexes: