Re: ip address data type

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
Cc: "Pgsql-Performance (E-mail)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ip address data type
Date: 2006-04-25 19:22:16
Message-ID: 87d5f54g0n.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Sriram Dandapani:

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

Queries like "host << '192.168.17.192/28'" use an available index on
the host column. In theory, you could do this with LIKE and strings,
but this gets pretty messy and needs a lot of client-side logic.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2006-04-25 19:57:59 Re: Large (8M) cache vs. dual-core CPUs
Previous Message Joshua D. Drake 2006-04-25 19:12:20 Re: Large (8M) cache vs. dual-core CPUs