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..
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2006-04-24 22:48:37|
|Subject: Re: ip address data type|
|Previous:||From: Tom Lane||Date: 2006-04-24 22:11:44|
|Subject: Re: Index on function less well cached than "regular" index ? |