Re: GSoC 2017 Proposal

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: Mark Rofail <markm(dot)rofail(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GSoC 2017 Proposal
Date: 2017-04-06 13:25:15
Message-ID: CAPpHfduuu-eynY1xGRCZvQCf2o29bUXaQ7X-1RkauiQ0=F6-Gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Mark!

On Mon, Apr 3, 2017 at 7:00 PM, Mark Rofail <markm(dot)rofail(at)gmail(dot)com> wrote:

> Kindly find my proposal attached to this email.
>

I'd like to ask what do you mean in research item number 3?

3. Making the full-table sequential scan GIN-indexable​ instead seems very
> reasonable since GIN is primarily used to search for element values (PK
> values) that appear within composite items (FK array).
> a. Statistics have shown[7] that GIN indexing an array shows an increase
> in performance by ~2256% !
> b. Thus the first step (as proposed ) would be to prove that “<@( is
> contained by)” can be used in this scope.

What exactly you're going to do in this item? Check that GIN index over
array support given operator, do the performance benchmark or something
else?

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2017-04-06 13:31:37 Re: [HACKERS] [GSoC] Push-based query executor discussion
Previous Message Arthur Zakirov 2017-04-06 13:24:33 Re: [PATCH] Generic type subscripting