Maintainers	No Maintainer
Categories	databases gis
Homepage	https://www.macports.org
Platforms	darwin
Variants	-

Subport(s) (12)

"pg14-postgis3" depends on

lib (0)

build (1)

extract (0)

run (0)

patch (0)

test (0)

fetch (0)

Ports that depend on "pg14-postgis3"

No ports

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.’