Re: Item compression in the Gist index

On Mon, 2022-05-02 at 14:48 +0200, Baca Radim wrote:
> we are developing an extension for multidimensional data. We have 
> created a Gist index that is heavily inspired by a cube extension. Right 
> now we would like to add some item compression since data items in a 
> node share a significant portion of a tuple prefix. However, I have no 
> idea how to handle information stored on a node level in Gists' 
> compression method. Is there any example? Unfortunately, the cube 
> extension does not implement item compression.
> To be more specific we would like to store in the node a common prefix 
> for all tuples in the node.
> Thanks for any advice,

Perhaps the PostGIS source will inspire you.  They are compressing an
entry to its bounding box.

Yours,
Laurenz Albe