Maintainers	Veence nilason
Categories	databases gis
Homepage	https://postgis.net/
Platforms	darwin
Variants	address_standardizer (Build with Address Standardizer support) lto (Build with Link Time Optimization (LTO)) proj6 (Use Proj6) proj7 (Use Proj7) proj8 (Use Proj8) proj9 (Use Proj9) raster (Build raster support) sfcgal (Uses SFCGAL for 3D queries) topology (Build topology support) universal (Build for multiple architectures)

Subport(s) (10)

"pg14-postgis3" depends on

lib (8)

build (6)

Ports that depend on "pg14-postgis3"

lib (1)

Port notes

! This version comes with the following warning if you use postgresql14:
‘Due to some query performance degradation with the new fast index build
that requires PG14, we have decided to disable the feature by default
until we get more user testing as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing:

ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);

and then reindex your gist indexes.
To revert back to the old index behavior:

ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
DROP FUNCTION 11 (geometry);

and then reindex your gist indexes.’