From: | Boris Muratshin <bmuratshin(at)gmail(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 3D Z-curve spatial index |
Date: | 2017-02-06 04:04:12 |
Message-ID: | CAO+8Nm4UPz60H8VUBzffnXASM83uQkgyrzpmuSW5E7Besd9JfQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)fetter(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Claudio Freire | 2017-02-06 04:05:16 | Re: ParallelFinish-hook of FDW/CSP (Re: Steps inside ExecEndGather) |
Previous Message | Claudio Freire | 2017-02-06 04:00:05 | Re: ParallelFinish-hook of FDW/CSP (Re: Steps inside ExecEndGather) |