PostGIS 3.0 is currently in alpha. It adds support for parallels processing of spatial queries which drastically increases the performance of spatial queries and makes PostGIS more inline with other advanced spatial databases. Please upgrade to this version of PostGIS when it is fully released.
Is there any roadmap for postgis 3.x support in azure at this point?
Mikko Laakko commented
PostgreSQL version 11 is supported by PostGIS 3.1 [https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS]
It would be good to have this added to Azure Database for PostgreSQL
Terje Wiig Mathisen commented
We have really large datasets where the improved performance would be a big help.
Sindre Seppola commented
We would love to see this feature in Azure! Our business rely on spatial queries on big datasets and this would improve the situation greatly.
PostGIS 3.1 is out.
New features: https://postgis.net/docs/manual-3.1/PostGIS_Special_Functions_Index.html#NewFunctions_3_1
Gregor Sanders commented
As soon as PostgreSQL 12 is adopted in Azure, Postgis 3 can leverage automatic parallel spatial queries and should be released at the same time:
Linda Sheard commented
PostGIS 3.0 was released 10/20/2019, and 3.1 is now in alpha. Please can you share the Azure PostgreSQL roadmap for updating from 2.5?
PostGIS 3.0 extends the support of generating GeoJson. It allows to take full records as input in opposite to just taking geometries into account. This helps to add properties right away instead of doing it in another layer.