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 <da...@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 >