Re: Need help!

Поиск
Список
Период
Сортировка
От Giuseppe Broccolo
Тема Re: Need help!
Дата
Msg-id CAFtuf8BTWsH5=EZu+WVWz6QNhqAa_xi9RF-WPjhgNZfEM19=cw@mail.gmail.com
обсуждение исходный текст
Ответ на Need help!  (FATIHI Ayoub <ayoubfatihi1999@gmail.com>)
Список pgsql-hackers
Hi Ayoub,

Il giorno mer 7 apr 2021 alle ore 17:29 FATIHI Ayoub <ayoubfatihi1999@gmail.com> ha scritto:
Hi postgres community,
I am willing to participate in GSoC to speed up the build of the gist index in postgis, which is based on postgresql.
And I need to know *everything* about the GiST API.
To do so I need to acquire the necessary theory and concepts to start this journey.
I do not have a computer science background, I have little knowledge about machines and I code in Python (for scientific computation, data science and ml).
So I am asking what I should learn to complete in an efficient way this task at hand: speeding up the build of gist index, if possible how much time is needed to accomplish each task.

The main thing you have to know IMO is the concept of "extensibility of indexes" in PostgreSQL. More specifically about GiST, you can have a look here:


Here there's also a note about the new added method of the API sortsupport, which is what you need for your task.

Giuseppe.

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: multi-install PostgresNode fails with older postgres versions
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ModifyTable overheads in generic plans