Re: SP-GiST for ranges based on 2d-mapping and quad-tree

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>

To: Alexander Korotkov <aekorotkov@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2012-07-03T14:26:08Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Teach SP-GiST to do index-only scans.
- 922036249340 9.2.0 cited

On Mon, 2012-07-02 at 23:47 -0700, Jeff Davis wrote:
> * Perhaps I'm mistaken, but the following code in getQuadrant() looks
> wrong to me, shouldn't the 1 and 2 be reversed?
> 
>         if (range_cmp_bounds(typcache, &upper, &centroidUpper) >= 0)
>             return 1;
>         else
>             return 2;

Oops, looks like I was mistaken. The code looks fine to me now.

Regards,
	Jeff Davis