Re: Yet another fast GiST build
От
Thomas Munro
Тема
Re: Yet another fast GiST build
Дата
Msg-id
CA+hUKGKZzJhYMOHHMqXJX-yif20VieYE8vYU_irycLksvem0JA@mail.gmail.com
Ответ на
Re: Yet another fast GiST build (Andrey Borodin)
Список
Дерево обсуждения
Yet another fast GiST build Andrey Borodin <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Yet another fast GiST build Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Yet another fast GiST build Andrey Borodin <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Andrey Borodin <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Andrey Borodin <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Michael Paquier <michael@paquier.xyz>
Re: Yet another fast GiST build Andrey Borodin <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Thomas Munro <thomas.munro@gmail.com>
Re: Yet another fast GiST build Thomas Munro <thomas.munro@gmail.com>
Re: Yet another fast GiST build Thomas Munro <thomas.munro@gmail.com>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Erik Rijkers <er@xs4all.nl>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Daniel Gustafsson <daniel@yesql.se>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Thomas Munro <thomas.munro@gmail.com>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Thomas Munro <thomas.munro@gmail.com>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build (typo) Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build (typo) "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Yet another fast GiST build Yuri Astrakhan <yuriastrakhan@gmail.com>
Re: Yet another fast GiST build Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Tom Lane <tgl@sss.pgh.pa.us>
Re: Yet another fast GiST build Tom Lane <tgl@sss.pgh.pa.us>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Yet another fast GiST build Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Yet another fast GiST build Heikki Linnakangas <hlinnaka@iki.fi>
Re: Yet another fast GiST build Oleg Bartunov <obartunov@postgrespro.ru>
Re: Yet another fast GiST build Pavel Borisov <pashkin.elfe@gmail.com>
Re: Yet another fast GiST build Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Yet another fast GiST build Peter Geoghegan <pg@bowt.ie>
Re: Yet another fast GiST build Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Yet another fast GiST build Peter Geoghegan <pg@bowt.ie>
Re: Yet another fast GiST build Alexander Korotkov <a.korotkov@postgrespro.ru>
On Mon, Dec 30, 2019 at 7:43 PM Andrey Borodin wrote:
> PFA rebased patch.
Hi Andrey,
This looks really interesting, and I am sure there are a lot of GIS
people who would love to see dramatically faster and smaller indexes
in PG13. I don't know enough to comment on the details, but here are
some superficial comments:
+ method is also optional and is used diring fast GiST build.
-> during
+ /* esteblish order between x and y */
-> establish
+/* Compute Z-oder for point */
static inline uint64
point_zorder_internal(Point *p)
-> order
Could this function please have a comment that explains why it works?
I mean, just a breadcrumb... the name of the technique or something...
so that uninitiated hackers can google their way to a clue (is it
"Morton encoding"?)
MSVC says:
src/backend/access/gist/gistproc.c(1582): error C2065: 'INT32_MAX' :
undeclared identifier
GCC says:
gistbuild.c: In function ‘gist_indexsortbuild’:
gistbuild.c:256:4: error: ISO C90 forbids mixed declarations and code
[-Werror=declaration-after-statement]
IndexTuple *itvec = gistextractpage(lower_page, &vect_len);
^
В списке pgsql-hackers по дате отправления