Re: [HACKERS] Index-only scans for multicolumn GIST

2014-07-23 Thread Emre Hasegeli
> That seems like a nonstarter :-(. Index-only scans don't have a license > to return approximations. If we drop the behavior for circles, how much > functionality do we have left? It should work with exact operator classes, box_ops, point_ops, range_ops, inet_ops. -- Sent via pgsql-hackers m

Re: [HACKERS] Index-only scans for multicolumn GIST

2014-07-22 Thread Tom Lane
Heikki Linnakangas writes: > 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? Tha

Re: [HACKERS] Index-only scans for multicolumn GIST

2014-07-22 Thread Robert Haas
On Tue, Jul 22, 2014 at 2:55 AM, Heikki Linnakangas wrote: > 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 >> GIST". >> Previous post is here: >> >> http://postgresql.1045698.n5.nabble.com/Index-onl

Re: [HACKERS] Index-only scans for multicolumn GIST

2014-07-21 Thread Heikki Linnakangas
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 GIST". Previous post is here: http://postgresql.1045698.n5.nabble.com/Index-only-scans-for-GIST-td5804892.html Repository is https://github.com/lubennikovaav/p

[HACKERS] Index-only scans for multicolumn GIST

2014-07-21 Thread Anastasia Lubennikova
Hi, hackers! There are new results of my work on GSoC project "Index-only scans for GIST". Previous post is here: http://postgresql.1045698.n5.nabble.com/Index-only-scans-for-GIST-td5804892.html Repository is https://github.com/lubennikovaav/postgres/tree/indexonlygist2 Patch is in attachments. It