Re: [HACKERS] GSoC 2017 Proposal

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: [HACKERS] GSoC 2017 Proposal
Дата
Msg-id CAPpHfduuu-eynY1xGRCZvQCf2o29bUXaQ7X-1RkauiQ0=F6-Gg@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hello, Mark!

On Mon, Apr 3, 2017 at 7:00 PM, Mark Rofail <markm.rofail@gmail.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
 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Arthur Zakirov
Дата:
Сообщение: Re: [HACKERS] [PATCH] Generic type subscripting
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: [HACKERS] [GSoC] Push-based query executor discussion