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

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 (view raw or flat)
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

pgsql-performance by date

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

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