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
Note:
See TracTickets
for help on using tickets.
In 17603: