On 07/21/2014 10:47 PM, Anastasia Lubennikova wrote:
Hi, hackers!
There are new results of my work on GSoC project "Index-only scans for
Previous post is here:

Repository is
Patch is in attachments.
It includes indexonlyscan for multicolumn GiST. It works correctly -
results are the same with another scan plans.
Fetch() method is realized for box and circle opclasses
Improvement for circle opclass is not such distinct as for box opclass,
because of recheck.

For a circle, the GiST index stores a bounding box of the circle. The new fetch function reverses that, calculating the radius and center of the circle from the bounding box.

Those conversions lose some precision due to rounding. Are we okay with that? Floating point math is always subject to rounding errors, but there's a good argument to be made that it's not acceptable to get a different value back when the user didn't explicitly invoke any math functions.

As an example:

create table circle_tbl (c circle);
create index circle_tbl_idx on circle_tbl using gist (c);
insert into circle_tbl values ('1.23456789012345,1.23456789012345,1e300');

postgres=# set enable_seqscan=off; set enable_bitmapscan=off; set enable_indexonlyscan=on;
postgres=# select * from circle_tbl ;
(1 row)

postgres=# set enable_indexonlyscan=off;
postgres=# select * from circle_tbl ;
(1 row)

- Heikki

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to