Re: Yet another fast GiST build
| От | Pavel Borisov |
|---|---|
| Тема | Re: Yet another fast GiST build |
| Дата | |
| Msg-id | CALT9ZEF_DHwJ+SmTj4t=3Oy2ErM6T-x17QsV=PhcME9e_CaoNQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Yet another fast GiST build ("Andrey M. Borodin" <x4mmm@yandex-team.ru>) |
| Ответы |
Re: Yet another fast GiST build
|
| Список | pgsql-hackers |
> Thanks! Did you measure the quality of the built index somehow? The
> ordering shouldn't make any difference to the build speed, but it
> affects the shape of the resulting index and the speed of queries
> against it.
Again I've tried random select tests near axes and haven't noticed any performance difference between ordinary gist build and z-ordered one. The same is for selects far from axes. Theoretically, there may be a possible slowdown for particular points inside the MBR which crosses the axis but I haven't tried to dig so deep and haven't tested performance as a function of coordinate.
So I feel this patch is not about select speed optimization.
В списке pgsql-hackers по дате отправления: