Re: [HACKERS] 3D Z-curve spatial index

Поиск
Список
Период
Сортировка
От Boris Muratshin
Тема Re: [HACKERS] 3D Z-curve spatial index
Дата
Msg-id CAO+8Nm4UPz60H8VUBzffnXASM83uQkgyrzpmuSW5E7Besd9JfQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] 3D Z-curve spatial index  (David Fetter <david@fetter.org>)
Ответы Re: [HACKERS] 3D Z-curve spatial index  (David Fetter <david@fetter.org>)
Список pgsql-hackers
The algorithm for 2D is described in articles (in Russian)
https://habrahabr.ru/post/319810/ and 
https://habrahabr.ru/post/319096/ .
Goggle-translator generates (IMHO) suitable for understanding text.

3D version article is not finished yet.

The data in figures are obtained in the following way:
1) Test data set is pseudo 3d (x,0,z) array of 100 000 000 random points
2) R-tree for comparison - GiST 2d (x,z)
3) There is a set of experiments by an average number of points in requested random area: 1,10, 100, 1 000, 10 000, 100 000, 1 000 000
4) For each area size I requested a set of random extents (from 100 000 times for 1 point to 100 times for 1 000 000 points).
5) Experiments were done on virtual machine (2 cores, 4Gb) and to exclude noise, all times were got on second (or more) run to warm caches,
    reads were got on restarted PosgreSQL.
6) For R-tree, times are very unstable and I used the least one in the series.

Regards, Boris







On Mon, Feb 6, 2017 at 5:08 AM, David Fetter <david@fetter.org> wrote:

Please send the actual patch and any documentation you write that
comes with it.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: ParallelFinish-hook of FDW/CSP (Re: [HACKERS] Steps inside ExecEndGather)
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: ParallelFinish-hook of FDW/CSP (Re: [HACKERS] Steps inside ExecEndGather)