And the query?
From: Shaozhong SHI
Sent: Monday, March 18, 2024 7:57 AM
To: Regina Obe
Cc: PostGIS Users Discussion
Subject: Re: PostGIS performance issue
product_assurance=# SELECT version(), postgis_full_version();
version
product_assurance=# SELECT version(), postgis_full_version();
version
|
postgis_full_version
Possible or one of the dependencies is different, or planner differences such
as the CTE changes that came in PostgreSQL 12, but hard to tell given the
information you have provided
Or you didn’t reindex your data after the upgrade to a newer version of
PostgreSQL and such a reindex was