forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit08612f4
committed
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 aflag in the cube header, and only store one copy of the coordinates. Thatcuts the on-disk size into half for the common case that the cube datatypeis used to represent points rather than boxes.The new format is backwards-compatible with the old one, so pg_upgradestill works. However, to get the space savings, the data needs to berewritten. A simple VACUUM FULL or REINDEX is not enough, as the oldDatums will just be moved to the new heap/index as is. A pg_dump andreload, or something similar like casting to text and back, will do thetrick.This patch deliberately doesn't update all the alternative expected outputfiles, as I don't have access to machines that produce those outputs. I'mnot sure if they are still relevant, but if they are, the buildfarm willtell us and produce the diff required to fix it. If none of the buildfarmanimals need them, they should be removed altogether.Patch by Stas Kelvich.1 parenta5963ef commit08612f4
File tree
6 files changed
+990
-222
lines changed- contrib/cube
- expected
- sql
6 files changed
+990
-222
lines changed0 commit comments
Comments
(0)