Thread: knngist plans

knngist plans

From
Marios Vodas
Date:
I would like to ask in which future version of postgresql knngist is planned to be included. Is there any possibility
tobe included in 9.1?<br /> 

Re: knngist plans

From
Robert Haas
Date:
On Wed, Oct 13, 2010 at 7:07 PM, Marios Vodas <mvodas@gmail.com> wrote:
> I would like to ask in which future version of postgresql knngist is planned
> to be included. Is there any possibility to be included in 9.1?

There's a possibility, but I think the patch still needs some more
work.  One thing that would help is if someone felt motivated to write
some documentation.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: knngist plans

From
Marios Vodas
Date:
Recently I worked a lot with gist and read about knngist. I have spotted weaknesses in docs. So I would be happy to
helpif you tell me how.<br /><br /><div class="gmail_quote">On Fri, Oct 15, 2010 at 5:57 AM, Robert Haas <span
dir="ltr"><<ahref="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Wed, Oct
13,2010 at 7:07 PM, Marios Vodas <<a href="mailto:mvodas@gmail.com">mvodas@gmail.com</a>> wrote:<br /> > I
wouldlike to ask in which future version of postgresql knngist is planned<br /> > to be included. Is there any
possibilityto be included in 9.1?<br /><br /></div>There's a possibility, but I think the patch still needs some
more<br/> work.  One thing that would help is if someone felt motivated to write<br /> some documentation.<br /><font
color="#888888"><br/> --<br /> Robert Haas<br /> EnterpriseDB: <a href="http://www.enterprisedb.com"
target="_blank">http://www.enterprisedb.com</a><br/> The Enterprise PostgreSQL Company<br
/></font></blockquote></div><br/> 

Re: knngist plans

From
Oleg Bartunov
Date:
On Fri, 15 Oct 2010, Marios Vodas wrote:

> Recently I worked a lot with gist and read about knngist. I have spotted
> weaknesses in docs. So I would be happy to help if you tell me how.

We have some documentation already, Teodor will post soon. Marios, 
I'd happy to help in writing docs. Do you have some plans ?

>
> On Fri, Oct 15, 2010 at 5:57 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>
>> On Wed, Oct 13, 2010 at 7:07 PM, Marios Vodas <mvodas@gmail.com> wrote:
>>> I would like to ask in which future version of postgresql knngist is
>> planned
>>> to be included. Is there any possibility to be included in 9.1?
>>
>> There's a possibility, but I think the patch still needs some more
>> work.  One thing that would help is if someone felt motivated to write
>> some documentation.
>>
>> --
>> Robert Haas
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


Re: knngist plans

From
Marios Vodas
Date:
Oleg as I said I do believe some things could get better in docs.<br />Here are 4 main drawbacks in my opinion:<br />1.
Thedocs lack example(s). There are some references to gistproc.c etc but this is not part of the docs and if I am
someonethat has just started this is hard and confusing (I shouldn't have to read the full technical solution to
anotherproblem in order to solve mine).<br /> 2. The 7 methods are poorly explained, at least theoretically. For
examplewhen I started I couldn't understand where each function was used. I had to read papers to understand the
logic.<br/>3. Describe situations that gist can be used. I am aware of spatial indexing because I worked on it, but I
havethe impression that there are more (e.g. computational biology).<br /> 4. Why not add some images/figures? (1 image
=1000 words)<br /><br />GiST is a very important and useful part of postgresql but it's hard to get started with it.
Moreover,I am sure it has capabilities, other than the profound, that are not known to many people (including me).<br
/>Plus knngist will give gist a boost, and I suggest that it shouldn't be delayed any more.<br /><br /><blockquote
class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> We
havesome documentation already, Teodor will post soon. </blockquote>I would really like to see what Teodor has done.<br
/><br/>I could also prepare a document with the additions I would like to see in docs. Shall I do it? Of course it
mighttake a while to finish it.<br /><br /><div class="gmail_quote">On Fri, Oct 15, 2010 at 2:37 PM, Oleg Bartunov
<spandir="ltr"><<a href="mailto:oleg@sai.msu.su">oleg@sai.msu.su</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Fri, 15
Oct2010, Marios Vodas wrote:<br /><br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Recently I worked a lot with gist and read about knngist. I have spotted<br /> weaknesses in
docs.So I would be happy to help if you tell me how.<br /></blockquote><br /></div> We have some documentation already,
Teodorwill post soon. Marios, I'd happy to help in writing docs. Do you have some plans ?<div class="im"><br /><br
/><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br /> On Fri,
Oct15, 2010 at 5:57 AM, Robert Haas <<a href="mailto:robertmhaas@gmail.com"
target="_blank">robertmhaas@gmail.com</a>>wrote:<br /><br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"> On Wed, Oct 13, 2010 at 7:07 PM, Marios Vodas <<a
href="mailto:mvodas@gmail.com"target="_blank">mvodas@gmail.com</a>> wrote:<br /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> I would like to ask in which future version of
postgresqlknngist is<br /></blockquote> planned<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"> to be included. Is there any possibility to be included in 9.1?<br
/></blockquote><br/> There's a possibility, but I think the patch still needs some more<br /> work.  One thing that
wouldhelp is if someone felt motivated to write<br /> some documentation.<br /><br /> --<br /> Robert Haas<br />
EnterpriseDB:<a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise
PostgreSQLCompany<br /><br /></blockquote><br /></blockquote><br /></div>        Regards,<br />                Oleg<br
/>_____________________________________________________________<br /><font color="#888888"> Oleg Bartunov, Research
Scientist,Head of AstroNet (<a href="http://www.astronet.ru" target="_blank">www.astronet.ru</a>),<br /> Sternberg
AstronomicalInstitute, Moscow University, Russia<br /> Internet: <a href="mailto:oleg@sai.msu.su"
target="_blank">oleg@sai.msu.su</a>,<a href="http://www.sai.msu.su/%7Emegera/"
target="_blank">http://www.sai.msu.su/~megera/</a><br/> phone: +007(495)939-16-83, +007(495)939-23-83<br
/></font></blockquote></div><br/> 

Re: knngist plans

From
Alvaro Herrera
Date:
Excerpts from Marios Vodas's message of sáb oct 16 11:11:52 -0300 2010:

> 4. Why not add some images/figures? (1 image = 1000 words)

I can answer this: the reason is that we haven't settled on a
technology for producing figures.  There's a thread about it, but no
consensus.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


Re: knngist plans

From
Oleg Bartunov
Date:
Marios,

you're right. There are several reasons for poor documentation, but of course,
no excuse, we do need good docs any way ! It's very nice you're willing to 
write one, since it's always better seen from outside of development.
I think it'd be better to use wiki, so other people can join.
Pictures would be nice, but I don't know if there is consensus about using 
pictures in documentation.



Oleg

btw, we're thinking in the background about new indexing infrastructure - 
Spatial GiST, but it's rather big project, so we need sponsors.

On Sat, 16 Oct 2010, Marios Vodas wrote:

> Oleg as I said I do believe some things could get better in docs.
> Here are 4 main drawbacks in my opinion:
> 1. The docs lack example(s). There are some references to gistproc.c etc but
> this is not part of the docs and if I am someone that has just started this
> is hard and confusing (I shouldn't have to read the full technical solution
> to another problem in order to solve mine).
> 2. The 7 methods are poorly explained, at least theoretically. For example
> when I started I couldn't understand where each function was used. I had to
> read papers to understand the logic.
> 3. Describe situations that gist can be used. I am aware of spatial indexing
> because I worked on it, but I have the impression that there are more (e.g.
> computational biology).
> 4. Why not add some images/figures? (1 image = 1000 words)
>
> GiST is a very important and useful part of postgresql but it's hard to get
> started with it. Moreover, I am sure it has capabilities, other than the
> profound, that are not known to many people (including me).
> Plus knngist will give gist a boost, and I suggest that it shouldn't be
> delayed any more.
>
> We have some documentation already, Teodor will post soon.
>
> I would really like to see what Teodor has done.
>
> I could also prepare a document with the additions I would like to see in
> docs. Shall I do it? Of course it might take a while to finish it.
>
> On Fri, Oct 15, 2010 at 2:37 PM, Oleg Bartunov <oleg@sai.msu.su> wrote:
>
>> On Fri, 15 Oct 2010, Marios Vodas wrote:
>>
>>  Recently I worked a lot with gist and read about knngist. I have spotted
>>> weaknesses in docs. So I would be happy to help if you tell me how.
>>>
>>
>> We have some documentation already, Teodor will post soon. Marios, I'd
>> happy to help in writing docs. Do you have some plans ?
>>
>>
>>
>>> On Fri, Oct 15, 2010 at 5:57 AM, Robert Haas <robertmhaas@gmail.com>
>>> wrote:
>>>
>>>  On Wed, Oct 13, 2010 at 7:07 PM, Marios Vodas <mvodas@gmail.com> wrote:
>>>>
>>>>> I would like to ask in which future version of postgresql knngist is
>>>>>
>>>> planned
>>>>
>>>>> to be included. Is there any possibility to be included in 9.1?
>>>>>
>>>>
>>>> There's a possibility, but I think the patch still needs some more
>>>> work.  One thing that would help is if someone felt motivated to write
>>>> some documentation.
>>>>
>>>> --
>>>> Robert Haas
>>>> EnterpriseDB: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>>
>>>
>>        Regards,
>>                Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/<http://www.sai.msu.su/%7Emegera/>
>> phone: +007(495)939-16-83, +007(495)939-23-83
>>
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


Re: knngist plans

From
Marios Vodas
Date:
On Sat, Oct 16, 2010 at 8:42 PM, Oleg Bartunov <oleg@sai.msu.su> wrote:
Marios,

you're right. There are several reasons for poor documentation, but of course,
no excuse, we do need good docs any way ! It's very nice you're willing to write one, since it's always better seen from outside of development.
I think it'd be better to use wiki, so other people can join.
Pictures would be nice, but I don't know if there is consensus about using pictures in documentation.

Wiki sounds good. Where can I find it?
 
Oleg

btw, we're thinking in the background about new indexing infrastructure - Spatial GiST, but it's rather big project, so we need sponsors.

 Is it related to SP-GIST (http://www.cs.purdue.edu/spgist/)?

Re: knngist plans

From
Oleg Bartunov
Date:
On Tue, 19 Oct 2010, Marios Vodas wrote:

> On Sat, Oct 16, 2010 at 8:42 PM, Oleg Bartunov <oleg@sai.msu.su> wrote:
>
>> Marios,
>>
>> you're right. There are several reasons for poor documentation, but of
>> course,
>> no excuse, we do need good docs any way ! It's very nice you're willing to
>> write one, since it's always better seen from outside of development.
>> I think it'd be better to use wiki, so other people can join.
>> Pictures would be nice, but I don't know if there is consensus about using
>> pictures in documentation.
>>
>
> Wiki sounds good. Where can I find it?

Lets start from this page.
http://wiki.postgresql.org/wiki/GiST
I think this page should be index page for all GiST documentation.


>
>
>> Oleg
>>
>> btw, we're thinking in the background about new indexing infrastructure -
>> Spatial GiST, but it's rather big project, so we need sponsors.
>
>
> Is it related to SP-GIST (http://www.cs.purdue.edu/spgist/)?

sort of.
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83