Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
PostgreSQL provider: use bounding box column to compute extent
Speeds up extent computation when custom indexed bbox column is
given. References #43835
  • Loading branch information
strk committed Jun 22, 2021
1 parent bb8ebb9 commit c9ad090
Showing 1 changed file with 1 addition and 1 deletion.
2 changes: 1 addition & 1 deletion src/providers/postgres/qgspostgresprovider.cpp
Expand Up @@ -3744,7 +3744,7 @@ QgsRectangle QgsPostgresProvider::extent() const
{
sql = QStringLiteral( "SELECT %1(%2%3) FROM %4%5" )
.arg( connectionRO()->majorVersion() < 2 ? "extent" : "st_extent",
quotedIdentifier( mGeometryColumn ),
quotedIdentifier( mBoundingBoxColumn ),
mSpatialColType == SctPcPatch ? "::geometry" : "",
mQuery,
filterWhereClause() );
Expand Down

0 comments on commit c9ad090

Please sign in to comment.