X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7B5ACD7BD4 for ; Thu, 3 Nov 2005 08:54:46 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56053-05 for ; Thu, 3 Nov 2005 12:54:42 +0000 (GMT) Received: from mail1.chaos1.de (Mail1.Chaos1.DE [213.160.12.53]) by svr1.postgresql.org (Postfix) with ESMTP id 2FCB3D6FFF for ; Thu, 3 Nov 2005 08:54:43 -0400 (AST) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.44) id 1EXecA-0004eh-6H; Thu, 03 Nov 2005 13:54:46 +0100 In-Reply-To: <11866.1130973734@sss.pgh.pa.us> References: <60328928649b77f3e95a407d47b400eb@Chaos1.DE> <11866.1130973734@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v623) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-sql@postgresql.org From: Axel Rau Subject: Re: Poor performance in inet << cidr join (Resolved) Date: Thu, 3 Nov 2005 13:54:36 +0100 To: Tom Lane X-Pgp-Agent: GPGMail 1.0.2 X-Mailer: Apple Mail (2.623) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.038 required=5 tests=[AWL=0.038] X-Spam-Score: 0.038 X-Spam-Level: X-Archive-Number: 200511/39 X-Sequence-Number: 23291 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 03.11.2005 um 00:22 schrieb Tom Lane: > Axel Rau writes: >> Question: Can rtree_inet be included in the core? > > No, because rtree is going away in 8.2. Feel like converting that > code to be a GIST opclass, instead? Perhaps. It would be a big step for me, since I started with pg 3 month ago. As starting points, I found - - chapter 48 in the 8.0 manual - - rtree_gist in 8.0 contrib - - btree_gist in 8.1 contrib Any more? Axel Axel Rau, Frankfurt, Germany +49-69-951418-0 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin) iQEVAwUBQ2oIlMFz9+6bacTRAQIwHQgAgOKK5rxY4aTrEStJeljORZwUWQre66ZD ZoD6HYcVxJepRC9lEbakxLmdokHtaMp1rqWziiv7idlDqApc6deVlo7ESozFC2jZ Yb/hVBIxmaBuHFj2n/AbYwGPR18g1SLODhyOj6/QlciKLw0apAVLUb0iHCfS7ie0 qSaCh/oARM8066SpMtdBX5oKLRgcgXYYtK9UNmX0njLqyDmCd9WZRrOwnLRRzptZ k5R1iMDrksV/Hifx9RcaGNRkQ4JZ15rf3OCLHgwMMwrpfLB0jMcBN8o1YEpZimJc Ffc5ChGlTfb4ADcCMGl3mBgBFNRoUZqMKrFakvEHJY65jz8ng3bl3w== =Hco5 -----END PGP SIGNATURE-----