Re: Space-GiST - Mailing list pgsql-advocacy

From Simon Riggs
Subject Re: Space-GiST
Date
Msg-id CA+U5nMJEF1sG+-rZBzP_Lbccj6tkY7LCeTRfNFwOJLV8vp61XA@mail.gmail.com
Whole thread Raw
In response to Re: Space-GiST  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-advocacy
On 11 May 2012 12:01, Oleg Bartunov <oleg@sai.msu.su> wrote:
> On Wed, 9 May 2012, Josh Berkus wrote:
>
>> Folks,
>>
>> Will PostgreSQL be the first production database to have a
>> space-partitioned-tree implementation, or does someone else have it
>> already?

More to the point: how does PostgreSQL implement them?

AFAICS the docs on that are completely absent. The docs mention kdtree
and quadtree but there is zero further discussion on how and when to
use them. (It says "read the source code"....)

How do you create an SP-GIST index? When would you?
How do you ask for kdtree? Which is the default: quad tree or kdtree?
What is the difference between them? Why have both?

I think we need to add that information before we add that to the
release notes as a major new feature.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-advocacy by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Space-GiST
Next
From: Magnus Hagander
Date:
Subject: Call for Papers - PostgreSQL Conference Europe 2012