Re: [HACKERS] Index-only scans for GiST.

2015-03-26 Thread Heikki Linnakangas
On 03/02/2015 12:43 AM, Heikki Linnakangas wrote: On 02/27/2015 04:19 PM, Anastasia Lubennikova wrote: I add MemoryContext listCxt to avoid memory leak. listCxt is created once in gistrescan (only for index-only scan plan ) and reseted when scan of the leaf page is finished. I do not sure if th

Re: [HACKERS] Index-only scans for GiST.

2015-03-01 Thread Heikki Linnakangas
On 02/27/2015 04:19 PM, Anastasia Lubennikova wrote: I add MemoryContext listCxt to avoid memory leak. listCxt is created once in gistrescan (only for index-only scan plan ) and reseted when scan of the leaf page is finished. I do not sure if the problem was completely solved, so I wait for feed

Re: [HACKERS] Index-only scans for GiST.

2015-02-27 Thread Anastasia Lubennikova
I add MemoryContext listCxt to avoid memory leak. listCxt is created once in gistrescan (only for index-only scan plan ) and reseted when scan of the leaf page is finished. I do not sure if the problem was completely solved, so I wait for feedback. * What's the reason for turning GISTScanOpaqueDa

Re: [HACKERS] Index-only scans for GiST.

2015-02-12 Thread Fabrízio de Royes Mello
On Thu, Feb 12, 2015 at 3:07 PM, Thom Brown wrote: > > On 12 February 2015 at 16:40, Heikki Linnakangas wrote: >> >> On 02/12/2015 12:40 PM, Anastasia Lubennikova wrote: >>> >>> Thanks for answer. >>> Now it seems to be applied correctly. >> >> >> * Documentation is missing. > > > Anastasia provi

Re: [HACKERS] Index-only scans for GiST.

2015-02-12 Thread Thom Brown
On 12 February 2015 at 16:40, Heikki Linnakangas wrote: > On 02/12/2015 12:40 PM, Anastasia Lubennikova wrote: > >> Thanks for answer. >> Now it seems to be applied correctly. >> > > * Documentation is missing. > Anastasia provided a documentation patch in the first email. Thom

Re: [HACKERS] Index-only scans for GiST.

2015-02-12 Thread Heikki Linnakangas
On 02/12/2015 12:40 PM, Anastasia Lubennikova wrote: Thanks for answer. Now it seems to be applied correctly. Thanks, it would be great to get this completed. This still leaks memory with the same test query as earlier. The leak seems to be into a different memory context now; it used to be t

Re: [HACKERS] Index-only scans for GiST.

2015-02-12 Thread Thom Brown
On 12 February 2015 at 10:40, Anastasia Lubennikova wrote: > Thanks for answer. > Now it seems to be applied correctly. > (please avoid top-posting) Thanks for the updated patch. I can confirm that it now cleanly applies and compiles fine. I've run the tested in the SQL file you provided, and

Re: [HACKERS] Index-only scans for GiST.

2015-02-12 Thread Anastasia Lubennikova
Thanks for answer. Now it seems to be applied correctly. 2015-02-12 3:12 GMT+04:00 Thom Brown : > On 11 February 2015 at 22:50, Anastasia Lubennikova < > lubennikov...@gmail.com> wrote: > >> Finally there is a new version of patch (in attachments). >> It provides multicolumn index-only scan for G

Re: [HACKERS] Index-only scans for GiST.

2015-02-11 Thread Thom Brown
On 11 February 2015 at 22:50, Anastasia Lubennikova wrote: > Finally there is a new version of patch (in attachments). > It provides multicolumn index-only scan for GiST indexes. > > - Memory leak is fixed. > - little code cleanup > - example of performance test in attachmens > - function OIDs ha

[HACKERS] Index-only scans for GiST.

2015-02-11 Thread Anastasia Lubennikova
Finally there is a new version of patch (in attachments). It provides multicolumn index-only scan for GiST indexes. - Memory leak is fixed. - little code cleanup - example of performance test in attachmens - function OIDs have debugging values (*) just to avoid merge conflicts while testing pa

Re: [HACKERS] Index-only scans for GIST

2014-10-27 Thread Thom Brown
On 18 August 2014 09:05, Heikki Linnakangas wrote: > On 08/17/2014 07:15 PM, Anastasia Lubennikova wrote: > >> 2014-08-07 0:30 GMT+04:00 Heikki Linnakangas : >> >> * I'm getting two regression failures with this (opr_sanity and join). >> >>> >>> >> opr_sanity failure is corrected. >> But there is

Re: [HACKERS] Index-only scans for GIST

2014-08-18 Thread Heikki Linnakangas
On 08/17/2014 07:15 PM, Anastasia Lubennikova wrote: 2014-08-07 0:30 GMT+04:00 Heikki Linnakangas : * I'm getting two regression failures with this (opr_sanity and join). opr_sanity failure is corrected. But there is remain question with join. I check the latest version of my github repo and

Re: [HACKERS] Index-only scans for GIST

2014-08-17 Thread Anastasia Lubennikova
Updated patch * Compiler, merge and regression fails checked * Regression tests was impoved * GiST and amcanreturn docs updated -- Best regards, Lubennikova Anastasia indexonlyscan_gist2.patch Description: Binary data indexonlyscan_gist_docs.patch Description: Binary data -- Sent via pgsql-h

Re: [HACKERS] Index-only scans for GIST

2014-08-17 Thread Anastasia Lubennikova
2014-08-07 0:30 GMT+04:00 Heikki Linnakangas : * I'm getting two regression failures with this (opr_sanity and join). > opr_sanity failure is corrected. But there is remain question with join. I check the latest version of my github repo and there's no fail in join regression test All 145 tests p

Re: [HACKERS] Index-only scans for GIST

2014-08-06 Thread Heikki Linnakangas
On 08/01/2014 10:58 AM, Anastasia Lubennikova 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 attachme

Re: [HACKERS] Index-only scans for GIST

2014-08-01 Thread Anastasia Lubennikova
Thank you for comment Patch is already added in Performance topic. 2014-08-01 20:25 GMT+04:00 Fabrízio de Royes Mello : > > On Fri, Aug 1, 2014 at 4:58 AM, Anastasia Lubennikova < > lubennikov...@gmail.com> wrote: > > > > Hi, hackers! > > I work on a GSoC project "Index-only scans for GIST" > >

Re: [HACKERS] Index-only scans for GIST

2014-08-01 Thread Fabrízio de Royes Mello
On Fri, Aug 1, 2014 at 4:58 AM, Anastasia Lubennikova < lubennikov...@gmail.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/pos

[HACKERS] Index-only scans for GIST

2014-08-01 Thread Anastasia Lubennikova
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

Re: [HACKERS] Index-only scans for GIST

2014-05-29 Thread Robert Haas
On Sun, May 25, 2014 at 6:12 AM, Anastasia Lubennikova wrote: > Hi, hackers! > There are first results of my work on GSoC project "Index-only scans for > GIST". Cool. > 1. Version of my project code is in forked repository > https://github.com/lubennikovaav/postgres/tree/indexonlygist2 > Patch i

[HACKERS] Index-only scans for GIST

2014-05-25 Thread Anastasia Lubennikova
Hi, hackers! There are first results of my work on GSoC project "Index-only scans for GIST". 1. Version of my project code is in forked repository https://github.com/lubennikovaav/postgres/tree/indexonlygist2 Patch is in attachments - This version is only for one-column indexes - fetch() method is