Opened 5 years ago

Closed 5 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.

Change History (1)

comment:1 Changed 5 years ago by strk

Resolution: fixed
Status: newclosed

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?)

Note: See TracTickets for help on using tickets.