#4676 closed enhancement (fixed)
Use PG_GETARG_GSERIALIZED_P_SLICE to access geometry headers
Reported by: | Algunenano | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.1.0 |
Component: | postgis | Version: | master |
Keywords: | Cc: |
Description
After the multiple improvements in PG12 in the partial decompression of toasted objects (thanks Paul), using PG_GETARG_GSERIALIZED_P_SLICE for toasted geometries can lead to big performance improvements in the functions that only need the geometry header.
A quick example using ST_SRID over huge geometries:
explain analyze Select ST_SRID(the_geom) from benchmark_4c7214d90a79aa6760367a084a4d4a2f61fbe1c6cc4f7f9e76020; -- Before latency average = 16.983 ms -- After latency average = 0.145 ms -- Perf: 117 x
Note:
See TracTickets
for help on using tickets.
Another example that shows how much of an impact can this make with big datasets: