Re: [HACKERS] Moving GiST index constant to parameter

2017-04-02 Thread Tom Lane
Thomas Mercieca writes: > I have tried introducing a GUC variable (entry in guc.c/config_real) and I > have also tried having the parser recognize it (same as fillfactor is > recognized), but irrelevant of what I set the value to at run-time, I always > get the same unusual

[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