Обсуждение: pgsql: Remove GIST concurrency limitations section.

Поиск
Список
Период
Сортировка

pgsql: Remove GIST concurrency limitations section.

От
momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
Log Message:
-----------
Remove GIST concurrency limitations section.

Christopher Kings-Lynne

Modified Files:
--------------
    pgsql/doc/src/sgml:
        gist.sgml (r1.20 -> r1.21)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/gist.sgml.diff?r1=1.20&r2=1.21)

Re: pgsql: Remove GIST concurrency limitations section.

От
Neil Conway
Дата:
Bruce Momjian wrote:
> Remove GIST concurrency limitations section.

- <para>
-  The current implementation of <acronym>GiST</acronym> within
-  <productname>PostgreSQL</productname> has some major limitations:
-  <acronym>GiST</acronym> index access is not concurrent, and the
-  <acronym>GiST</acronym> interface doesn't allow the development of
certain
-  data types, such as digital trees (see papers by Aoki et al).
- </para>

AFAIK the GiST modifications suggested Aoki have not yet been
implemented, so this should not have been removed.

-Neil

Re: pgsql: Remove GIST concurrency limitations section.

От
Oleg Bartunov
Дата:
On Sun, 3 Jul 2005, Neil Conway wrote:

> Bruce Momjian wrote:
>> Remove GIST concurrency limitations section.
>
> - <para>
> -  The current implementation of <acronym>GiST</acronym> within
> -  <productname>PostgreSQL</productname> has some major limitations:
> -  <acronym>GiST</acronym> index access is not concurrent, and the
> -  <acronym>GiST</acronym> interface doesn't allow the development of certain
> -  data types, such as digital trees (see papers by Aoki et al).
> - </para>
>
> AFAIK the GiST modifications suggested Aoki have not yet been implemented, so
> this should not have been removed.

yes, this is the next step of our work on GiST. Call for support :)

>
> -Neil
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: pgsql: Remove GIST concurrency limitations section.

От
Christopher Kings-Lynne
Дата:
> - <para>
> -  The current implementation of <acronym>GiST</acronym> within
> -  <productname>PostgreSQL</productname> has some major limitations:
> -  <acronym>GiST</acronym> index access is not concurrent, and the
> -  <acronym>GiST</acronym> interface doesn't allow the development of
> certain
> -  data types, such as digital trees (see papers by Aoki et al).
> - </para>
>
> AFAIK the GiST modifications suggested Aoki have not yet been
> implemented, so this should not have been removed.

I thought that was an extremely vague limitation and could easily be
removed...  It's like having a limitations section on btrees and have
mentioning in passing that it can't do full text indexing or something.

Chris

Re: pgsql: Remove GIST concurrency limitations section.

От
Tom Lane
Дата:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> AFAIK the GiST modifications suggested Aoki have not yet been
>> implemented, so this should not have been removed.

> I thought that was an extremely vague limitation and could easily be
> removed...  It's like having a limitations section on btrees and have
> mentioning in passing that it can't do full text indexing or something.

Yeah, I agree.  It'd be appropriate to mention the Aoki paper in TODO,
but we don't normally document "stuff we'd like to do someday" as
serious limitations.

            regards, tom lane

Re: pgsql: Remove GIST concurrency limitations section.

От
Oleg Bartunov
Дата:
On Mon, 4 Jul 2005, Christopher Kings-Lynne wrote:

>> - <para>
>> -  The current implementation of <acronym>GiST</acronym> within
>> -  <productname>PostgreSQL</productname> has some major limitations:
>> -  <acronym>GiST</acronym> index access is not concurrent, and the
>> -  <acronym>GiST</acronym> interface doesn't allow the development of
>> certain
>> -  data types, such as digital trees (see papers by Aoki et al).
>> - </para>
>>
>> AFAIK the GiST modifications suggested Aoki have not yet been implemented,
>> so this should not have been removed.
>
> I thought that was an extremely vague limitation and could easily be
> removed...  It's like having a limitations section on btrees and have
> mentioning in passing that it can't do full text indexing or something.

ok, it's sort of TODO

>
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: pgsql: Remove GIST concurrency limitations section.

От
Bruce Momjian
Дата:
Oleg Bartunov wrote:
> On Mon, 4 Jul 2005, Christopher Kings-Lynne wrote:
>
> >> - <para>
> >> -  The current implementation of <acronym>GiST</acronym> within
> >> -  <productname>PostgreSQL</productname> has some major limitations:
> >> -  <acronym>GiST</acronym> index access is not concurrent, and the
> >> -  <acronym>GiST</acronym> interface doesn't allow the development of
> >> certain
> >> -  data types, such as digital trees (see papers by Aoki et al).
> >> - </para>
> >>
> >> AFAIK the GiST modifications suggested Aoki have not yet been implemented,
> >> so this should not have been removed.
> >
> > I thought that was an extremely vague limitation and could easily be
> > removed...  It's like having a limitations section on btrees and have
> > mentioning in passing that it can't do full text indexing or something.
>
> ok, it's sort of TODO

Added to TODO:

    * Allow GIST indexes to create certain complex index types, like digital
      trees (see Aoki)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073