Re: Poor performance in inet << cidr join (Resolved)

From: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Poor performance in inet << cidr join (Resolved)
Date: 2005-11-03 12:54:36
Message-ID: deef0c5d4a31e9cf3bea8bc904d52530@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am 03.11.2005 um 00:22 schrieb Tom Lane:

> Axel Rau <Axel(dot)Rau(at)Chaos1(dot)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-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2005-11-03 13:59:01 Slow query - SELECTing one row from 'big' table.
Previous Message Richard Huxton 2005-11-03 07:48:45 Re: User input in psql