This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Commit 08612f4

committed

Oct 21, 2013

Extend cube on-disk format to pack points more tightly.

If the lower left and upper right corners of a cube are the same, set a flag in the cube header, and only store one copy of the coordinates. That cuts the on-disk size into half for the common case that the cube datatype is used to represent points rather than boxes. The new format is backwards-compatible with the old one, so pg_upgrade still works. However, to get the space savings, the data needs to be rewritten. A simple VACUUM FULL or REINDEX is not enough, as the old Datums will just be moved to the new heap/index as is. A pg_dump and reload, or something similar like casting to text and back, will do the trick. This patch deliberately doesn't update all the alternative expected output files, as I don't have access to machines that produce those outputs. I'm not sure if they are still relevant, but if they are, the buildfarm will tell us and produce the diff required to fix it. If none of the buildfarm animals need them, they should be removed altogether. Patch by Stas Kelvich.

1 parent a5963ef commit 08612f4Copy full SHA for 08612f4

6 files changed

+990

-222

lines changed

contrib/cube
- cube.c
- cubedata.h
- cubeparse.y
- expected
  - cube_1.out
  - cube_2.out
- sql
  - cube.sql

6 files changed

+990

-222

lines changed

There was a problem loading the remainder of the diff.

Comments

(0)

Failed to load comments.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Commit 08612f4

6 files changed

6 files changed

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!

File tree

6 files changed

6 files changed

There are no files selected for viewing

0 commit comments

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!