Skip site navigation (1) Skip section navigation (2)

ip address data type

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: "Pgsql-Performance \(E-mail\)" <pgsql-performance(at)postgresql(dot)org>
Subject: ip address data type
Date: 2006-04-24 22:45:14
Message-ID: 6992E470F12A444BB787B5C937B9D4DF0406B11B@ca-mail1.cis.local (view raw or flat)
Thread:
Lists: pgsql-performance
Hi

 

I have queries that use like operators and regex patterns to determine
if an ip address is internal or external (this is against a table with
say 100 million distinct ip addresses).

 

Does the inet data type offer comparison/search performance benefits
over plain text for ip addresses..

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-04-24 22:48:37
Subject: Re: ip address data type
Previous:From: Tom LaneDate: 2006-04-24 22:11:44
Subject: Re: Index on function less well cached than "regular" index ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group