X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5D82111F6109 for ; Tue, 25 Apr 2006 16:22:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11892-10 for ; Tue, 25 Apr 2006 16:22:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2078B11F6081 for ; Tue, 25 Apr 2006 16:22:24 -0300 (ADT) Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by svr4.postgresql.org (Postfix) with ESMTP id C9EDE5B3163 for ; Tue, 25 Apr 2006 19:22:24 +0000 (GMT) Received: from deneb.vpn.enyo.de ([212.9.189.177] helo=deneb.enyo.de) by mail.enyo.de with esmtp id 1FYT74-0006i7-9D; Tue, 25 Apr 2006 21:22:18 +0200 Received: from fw by deneb.enyo.de with local (Exim 4.61) (envelope-from ) id 1FYT72-0002va-Tg; Tue, 25 Apr 2006 21:22:16 +0200 From: Florian Weimer To: "Sriram Dandapani" Cc: "Pgsql-Performance (E-mail)" Subject: Re: ip address data type References: <6992E470F12A444BB787B5C937B9D4DF0406B11B@ca-mail1.cis.local> Date: Tue, 25 Apr 2006 21:22:16 +0200 In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF0406B11B@ca-mail1.cis.local> (Sriram Dandapani's message of "Mon, 24 Apr 2006 15:45:14 -0700") Message-ID: <87d5f54g0n.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/572 X-Sequence-Number: 18656 * 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.