Opened 10 years ago
Closed 10 years ago
#2745 closed enhancement (fixed)
ST_Simplify(point_type) overhead
| Reported by: | strk | Owned by: | strk |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.1.4 |
| Component: | postgis | Version: | 2.1.x |
| Keywords: | Cc: |
Description
I saw an overhead of x4 calling ST_Simplify() against 800k point records. Looking at the code it could be due to the deserialization/serialization step performed. We could skip that.
Note:
See TracTickets
for help on using tickets.
r12576 in 2.1 branch, r12577 in trunk. The overhead is still x2, but I dubt there's anything we can do there (I guess it's the overhead of calling a function as the DETOAST should happen only once within a statment, right?)