PostGIS 3.1.0beta1

Author: Paul Ramsey 2020/12/09 in news ( release, 3.1, 3.1.0beta1 )

The PostGIS Team is pleased to release the first beta of the upcoming PostGIS 3.1.0 release. This version is exposes some of the new performance and feature enhancements in not yet relesed GEOS 3.9 as well as numerous speed enhancements not requiring newer GEOS. Requires GEOS 3.6+ and PostgreSQL 9.6+. To use MVT you will need protobuf-c 1.1. or higher.

Best served with:

PostgreSQL 13.1, GEOS 3.7 or higher is recommended.
pgRouting 3.1.1

3.1.beta1

Details of this release can be found in the NEWS file: https://git.osgeo.org/gitea/postgis/postgis/src/tag/3.1.0beta1/NEWS

If you come across any issues, feel free to report via our ticket tracker https://trac.osgeo.org/postgis or mailing list with details as described here - https://postgis.net/support/

View all tickets for 3.1.0 milestone.

Breaking changes

#4214, Deprecated STCount(tablename,…), STApproxCount(tablename, …) STSummaryStats(tablename, ..), STHistogram(tablename, …), STApproxHistogram(tablename, …), STQuantile(tablename, …), ST_ApproxQuantile(tablename, …) removed. (Darafei Praliaskouski)

Enhancements

#4801, ST_ClusterKMeans supports weights in POINT[Z]M geometries (Darafei Praliaskouski)
#4804, ST_ReducePrecision (GEOS 3.9+) allows valid precision reduction (Paul Ramsey)
#4805, STSortableHash exposed to work around parallel soring performance issue in Postgres. If your table is huge, use ORDER BY STSortableHash(geom) instead of ORDER BY geom to make parallel sort faster (Darafei Praliaskouski)
#4625, Correlation statistics now calculated. Run ANALYZE for BRIN indexes to start kicking in. (Darafei Praliaskouski)
Fix axis order issue with urn:ogc:def:crs:EPSG in ST_GeomFromGML() (Even Roualt)

PostGIS 3.1.0

The PostGIS Team is pleased to release the release of PostGIS 3.1.0!

This version exposes the new features of GEOS 3.9 as well as numerous core performance enhancements for spatial joins, large object access, text format output and more.

Performance is a key feature of this release, with improvements to spatial joins, text outputs, large object reads, vector tile output, and a host of smaller tweaks.

The k-means clustering code has been enhanced to support weighting and higher dimensional clusters.

Geometry generators to create hexagonal and square tilings have been added, for simpler in-the-database summarization queries.

Finally, PostGIS exposes the latest enhancements in the GEOS geometry library 3.9 version. The new overlay engine (aka “OverlayNG”) provides more robust handling of difficult input geometries, using a set of new noding strategies to process geometry. For the end user, this should mean no more “topology exceptions” when using the union, difference, intersection or symmetric difference functions. PostGIS also exposes the new fixed precision overlay capability via an additional grid-size parameter on ST_Intersection and the other overlay functions.

PostGIS 3.1.0rc1

The PostGIS Team is pleased to release the release candidate of the upcoming PostGIS 3.1.0 release. This version is exposes some of the new performance and feature enhancements in GEOS 3.9 as well as numerous speed enhancements not requiring newer GEOS.

Best served with:

PostGIS

Spatial and Geographic objects for PostgreSQL

PostGIS 3.1.0beta1

More Posts

PostGIS 3.1.0

PostGIS 3.1.0rc1

Site Map

PostGIS Project Steering Committee (PSC)