Postgres Pro
Downloads
Home   >   mailing lists

ip address data type - Mailing list pgsql-performance

From Sriram Dandapani
Subject ip address data type
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF0406B11B@ca-mail1.cis.local
Whole thread Raw
Responses Re: ip address data type  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: ip address data type  (Steve Atkins <steve@blighty.com>)
Re: ip address data type  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-performance
Tree view

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..

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index on function less well cached than "regular" index ?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: ip address data type