Re: Index-only scans for GIST

From: Anastasia Lubennikova <lubennikovaav(at)gmail(dot)com>
To: Fabrízio Mello <fabriziomello(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index-only scans for GIST
Date: 2014-08-01 16:46:44
Message-ID: CAP4vRV7xpFq_YQnqXOgj=K5aJ5WY7=wczaXSWZ92zFMGUXy0aw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thank you for comment
Patch is already added in Performance topic.

2014-08-01 20:25 GMT+04:00 Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
:

>
> On Fri, Aug 1, 2014 at 4:58 AM, Anastasia Lubennikova <
> lubennikovaav(at)gmail(dot)com> wrote:
> >
> > Hi, hackers!
> > I work on a GSoC project "Index-only scans for GIST"
> >
> https://wiki.postgresql.org/wiki/Support_for_Index-only_scans_for_GIST_GSoC_2014
> >
> > Repository is
> > https://github.com/lubennikovaav/postgres/tree/indexonlygist2
> > Patch is in attachments.
> >
> > It includes index-only scans for multicolumn GIST and new regression
> test.
> > Fetch() method is realized for box and point opclasses.
> >
> > Documentation is not updated yet, but I'm going to do it till the end of
> GSoC.
> >
> > I've got one question about query with OR condition. It is the last
> query in regression test "gist_indexonly". It doesn't fail but it doensn't
> use index-only scans. Could someone explain to me how it works?
> > It seems to depend on build_paths_for_OR function. But I couldn't
> understand how.
> >
>
> Very nice... please add your patch to the next commit fest [1].
>
> Regards,
>
>
> [1] https://commitfest.postgresql.org/action/commitfest_view?id=23
>
> --
> Fabrízio de Royes Mello
> Consultoria/Coaching PostgreSQL
> >> Timbira: http://www.timbira.com.br
> >> Blog sobre TI: http://fabriziomello.blogspot.com
> >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
> >> Twitter: http://twitter.com/fabriziomello
>

--
Best regards,
Lubennikova Anastasia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2014-08-01 16:47:16 Re: Bug of pg_receivexlog -v
Previous Message desmodemone 2014-08-01 16:43:45 Re: Proposal: Incremental Backup