From: Axel Rau <Axel.Rau@Chaos1.DE>
To: pgsql-sql@postgresql.org
Subject: Re: Poor performance in inet << cidr join (Resolved)
Date: Wed, 2 Nov 2005 23:07:39 +0100
Message-ID: <60328928649b77f3e95a407d47b400eb@Chaos1.DE> (raw)
In-Reply-To: <a366b1ecc7f4d6f4b139106cf524f2e7@Chaos1.DE>
References: <a366b1ecc7f4d6f4b139106cf524f2e7@Chaos1.DE>
Am 31.10.2005 um 19:53 schrieb Axel Rau:
> The planner does not use the pk-indices. Poking around,
> I could not find an operator class, which supports the containment
> ('<<') operator.
> Is my conclusion correct?
> How can the functionality be extended?
> Is there any implementation available?
rtree_inet from John Hansen does the trick:
http://archives.postgresql.org/pgsql-hackers/2005-01/msg01038.php
First test shows query time of 85 instead of 2745 seconds:
QUERY PLAN
------------------------------------------------------------------------
-------------------------
Aggregate (cost=1768557.75..1768557.75 rows=1 width=0)
-> Seq Scan on event e (cost=0.00..1768040.83 rows=206769 width=0)
Filter: (NOT (subplan))
SubPlan
-> Index Scan using network_id_rtree on network n
(cost=0.00..21.28 rows=5 width=0)
Index Cond: ($0 &<< (id)::inet)
Question: Can rtree_inet be included in the core?
Axel
Axel Rau, Frankfurt, Germany +49-69-951418-0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Axel.Rau@Chaos1.DE
Subject: Re: Poor performance in inet << cidr join (Resolved)
In-Reply-To: <60328928649b77f3e95a407d47b400eb@Chaos1.DE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox