Opened 5 years ago

Closed 5 years ago

#4453 closed enhancement (fixed)

Optimize ST_IsEmpty by avoiding deserialization

Reported by: Algunenano Owned by: Algunenano
Priority: medium Milestone: PostGIS 3.0.0
Component: postgis Version: master
Keywords: Cc:

Description

As <subject> says, there is no need to deserialize a geometry to know if it's empty. 

EXPLAIN ANALYZE Select ST_IsEmpty(the_geom_webmercator) from benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293;

Before: 

number of transactions actually processed: 98
latency average = 204.691 ms

After: 

number of transactions actually processed: 120
latency average = 167.220 ms

GH PR: ​https://github.com/postgis/postgis/pull/442

Change History (1)

comment:1 by Raul Marin, 5 years ago

Resolution: → fixed
Status: assigned → closed

In 17603:

ST_IsEmpty: Speed up by avoiding deserialization

Closes #4453
Closes ​https://github.com/postgis/postgis/pull/442

Note: See TracTickets for help on using tickets.