[postgis-users] Experiences with the new faster GiST building in PostGIS 3.2 and PostgreSQL 14?

[Marco Boeringa]

Hi all,

Now with the betas out for PostGIS 3.2, I was wondering if anyone has 
some real world comparative figures to share for creating spatial 
indexes using GiST in PostGIS 3.2 and PostgreSQL 14, versus the older 
GiST implementation in previous versions?

Creating spatial indexes on e.g. OpenStreetMap sized datasets is still 
an expensive operation, and any gains in the latest releases would be 
highly welcome. Has someone done a comparison between releases that 
might give all of us that haven't yet upgraded, an idea of possible 
benefits of the new implementation?

Marco