Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] 3D Z-curve spatial index - Mailing list pgsql-hackers

From Boris Muratshin
Subject [HACKERS] 3D Z-curve spatial index
Date
Msg-id CAO+8Nm6LJ-NdYBTVk1Giko=HT5JFAMdfmS5OaBf_k+-sgvur5w@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] 3D Z-curve spatial index
List pgsql-hackers
Tree view
Hi hackers,

The low-level implementation of 3D Z-curve index
(https://github.com/bmuratshin/zcurve/tree/master)
is getting close to GiST R-Tree performance at
significantly lesser number of pages read from disk.

See attached figures, 
times2 - average request execution time VS average points number in result 
reads2 - average shared reads number VS average points number in result 

Feel free to connect with me if you have any questions.
Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: \if, \elseif, \else, \endif (was Re: [HACKERS] PSQL commands:\quit_if, \quit_unless)
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pgbench more operators & functions