[postgis-devel] Bit setting to compress PostGIS geometries

Darafei "Komяpa" Praliaskouski me at komzpa.net
Wed Mar 7 07:31:46 PST 2018


> As far as merging this in, are there objections to the function name
> "postgis_compress_geometry" ? While the compression is actually happening
> at the Postgres level, I think this name captures the net result of calling
> the function, doesn't require the user to understand the internal mechanism
> of compression, and suggests that use of the function alters the input data
> and may affect performance.
>

compress_geometry will not kick in if column type is altered to EXTERNAL or
PLAIN:
https://www.postgresql.org/docs/10/static/storage-toast.html

I would expect compress_geometry to change internal representation to some
zigzag delta encoded thing, but not to zero out last bits.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180307/25397674/attachment.html>


More information about the postgis-devel mailing list