[HACKERS] Extracting GiST index structure stats?

2017-04-15 Thread Thomas Mercieca
Hi all, I am interested in getting simple statistics of a GiST index structure. For example, height of tree. It seems that the other indexes have a metapage for this. I am still unsure but it looks to me like the GiST access method internal does not work exactly in this way so it is a bit more

[HACKERS] Moving GiST index constant to parameter

2017-04-02 Thread Thomas Mercieca
Hi all, The GiST index has a picksplit support procedure (in gistproc.c) with a constant set up using #define - LIMIT_RATIO, set to 0.3. The PostGIS extension which shares similar code for GiST has this set to 0.1 (gserialized_gist_picksplit_2d.c). Compiling new builds, I could see a differenc