Re: ip address data type - Mailing list pgsql-performance

From Florian Weimer
Subject Re: ip address data type
Date
Msg-id 87d5f54g0n.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to ip address data type  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List 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.

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Large (8M) cache vs. dual-core CPUs
Next
From: David Boreham
Date:
Subject: Re: Large (8M) cache vs. dual-core CPUs