Tom Lane wrote: > > Oleg Bartunov <[EMAIL PROTECTED]> writes: > > seems rtree doesn't ignore NULL ? > > Hm, maybe not. There are explicit tests to ignore null inputs in hash > indexes (hash/hash.c), and I'd just sort of assumed that rtree and gist > do the same. > > FWIW, your example doesn't seem to provoke an error in current sources; > but it does take quite a long time (far longer than building a btree > index on 10000 nulls). That makes me think that indexing nulls in rtree > might be a bad idea even if it works. Or maybe just some optimisations done for large number of similar keys ( probabilistic page-splitting or some such ;) in btree are not done in rtree ? ---------- Hannu
- Re: [HACKERS] Who is a maintainer ... Hannu Krosing
- Re: [HACKERS] Who is a maintainer ... Tom Lane
- Re: [HACKERS] Who is a maintainer ... Oleg Bartunov
- Re: [HACKERS] Who is a maintainer ... Tom Lane
- Re: [HACKERS] Who is a maintainer ... Oleg Bartunov
- Re: [HACKERS] Who is a maintainer ... Tom Lane
- Re: [HACKERS] Who is a maintainer ... Thomas Lockhart
- Re: [HACKERS] Who is a maintainer ... Hannu Krosing
- Re: [HACKERS] Who is a maintainer ... Oleg Bartunov
- Re: [HACKERS] Who is a maintainer ... Hannu Krosing
- [HACKERS] GiST for 7.1 !! Hannu Krosing
- [HACKERS] GiST for 7.1 !! Oleg Bartunov
- [HACKERS] Re: GiST for 7.1 !! Tom Lane
- Re: [HACKERS] Re: GiST for 7.1 !! Oleg Bartunov
- Re: [HACKERS] Re: GiST for 7.1 !! The Hermit Hacker
- Re: [HACKERS] Re: GiST for 7.1 !! Hannu Krosing
- [HACKERS] Re: [DOCS] 7.1 features list Ryan Kirkpatrick
- Re: [HACKERS] Re: [DOCS] 7.1 features list Bruce Momjian