pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Poor performance in inet << cidr join (Resolved)
3+ messages / 2 participants
[nested] [flat]
* Re: Poor performance in inet << cidr join (Resolved)
@ 2005-11-02 22:07 Axel Rau <Axel.Rau@Chaos1.DE>
2005-11-02 23:22 ` Re: Poor performance in inet << cidr join (Resolved) Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Axel Rau @ 2005-11-02 22:07 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Poor performance in inet << cidr join (Resolved)
2005-11-02 22:07 Re: Poor performance in inet << cidr join (Resolved) Axel Rau <Axel.Rau@Chaos1.DE>
@ 2005-11-02 23:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-03 12:54 ` Re: Poor performance in inet << cidr join (Resolved) Axel Rau <Axel.Rau@Chaos1.DE>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-11-02 23:22 UTC (permalink / raw)
To: Axel Rau <Axel.Rau@Chaos1.DE>; +Cc: pgsql-sql
Axel Rau <Axel.Rau@Chaos1.DE> 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?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Poor performance in inet << cidr join (Resolved)
2005-11-02 22:07 Re: Poor performance in inet << cidr join (Resolved) Axel Rau <Axel.Rau@Chaos1.DE>
2005-11-02 23:22 ` Re: Poor performance in inet << cidr join (Resolved) Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-11-03 12:54 ` Axel Rau <Axel.Rau@Chaos1.DE>
0 siblings, 0 replies; 3+ messages in thread
From: Axel Rau @ 2005-11-03 12:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Am 03.11.2005 um 00:22 schrieb Tom Lane:
> Axel Rau <Axel.Rau@Chaos1.DE> 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-----
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-11-03 12:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-02 22:07 Re: Poor performance in inet << cidr join (Resolved) Axel Rau <Axel.Rau@Chaos1.DE>
2005-11-02 23:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-03 12:54 ` Axel Rau <Axel.Rau@Chaos1.DE>
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