| From: | Stas Kelvich <stas(dot)kelvich(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-students(at)postgresql(dot)org | 
| Subject: | Cube extension point support // GSoC'13 | 
| Date: | 2013-07-12 11:57:49 | 
| Message-ID: | 23364502-F542-4553-A658-4D3A2B6FCFA9@gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers pgsql-students | 
Hello.
here is a patch adding to cube extension support for compressed representation of point cubes. If cube is a point, i.e. has coincident lower left and upper right corners, than only one corner is stored. First bit of the cube header indicates whether the cube is point or not. Few moments:
* Patch preserves binary compatibility with old indices
* All functions that create cubes from user input, check whether it is a point or not
* All internal functions that can return cubes takes care of all cases where a cube might become a point
* Added tests for checking correct point behavior
Also this patch includes adapted Alexander Korotkov's patch with kNN-based ordering operator, which he wrote for postgresql-9.0beta1 with knngist patch. More info there http://www.postgresql.org/message-id/AANLkTimhFaq6hCibRnk0tlcQMIyhYWHwAQ2ZD87wbH86@mail.gmail.com
Stas Kelvich
| Attachment | Content-Type | Size | 
|---|---|---|
| points.patch | application/octet-stream | 55.6 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2013-07-12 12:30:37 | Re: refresh materialized view concurrently | 
| Previous Message | Magnus Hagander | 2013-07-12 10:30:20 | Re: docbook-xsl version for release builds | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2013-07-17 07:49:51 | Re: [HACKERS] Cube extension point support // GSoC'13 | 
| Previous Message | David Fetter | 2013-07-08 01:35:36 | Re: UPDATE... RETURNING AFTER/BEFORE |