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

Поиск
Список
Период
Сортировка
От Axel Rau
Тема Re: Poor performance in inet << cidr join (Resolved)
Дата
Msg-id deef0c5d4a31e9cf3bea8bc904d52530@Chaos1.DE
обсуждение исходный текст
Ответ на Re: Poor performance in inet << cidr join (Resolved)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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-----



В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: User input in psql
Следующее
От: Mario Splivalo
Дата:
Сообщение: Slow query - SELECTing one row from 'big' table.