X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 633A5D1B90E for ; Tue, 24 Feb 2004 15:23:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74448-04 for ; Tue, 24 Feb 2004 11:23:27 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id D906FD1B4C5 for ; Tue, 24 Feb 2004 11:23:22 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1OFNMgM022240; Tue, 24 Feb 2004 10:23:23 -0500 (EST) To: "Eric Jain" Cc: "Steve Atkins" , "pgsql-performance" Subject: Re: Slow join using network address function In-reply-to: <001d01c3face$bca62d40$c300000a@caliente> References: <000701c3fa02$e4e3d180$c300000a@caliente> <20040223160734.GA11052@gp.word-to-the-wise.com> <001d01c3face$bca62d40$c300000a@caliente> Comments: In-reply-to "Eric Jain" message dated "Tue, 24 Feb 2004 13:07:10 +0100" Date: Tue, 24 Feb 2004 10:23:22 -0500 Message-ID: <22239.1077636202@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/277 X-Sequence-Number: 5801 "Eric Jain" writes: >> is a datatype that contains >> a range of IPv4 addresses, and which has the various operators to >> make it GIST indexable. > Great, this looks very promising. >> No cast operators between ipr and inet types. > Any way to work around this, short of dumping and reloading tables? Wouldn't it be better to implement the GIST indexing operators of that package on the standard datatypes? It wasn't apparent to me what "range of IP addresses" does for you that isn't covered by "CIDR subnet" for real-world cases. regards, tom lane