[postgis-devel] Bit setting to compress PostGIS geometries

[Regina Obe]

Sounds good to me.  Would love to reduce the tiger data set size I use for geocoding in particular.

 

Thanks,

Regina

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Daniel Baston
Sent: Friday, February 16, 2018 9:38 AM
To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Subject: [postgis-devel] Bit setting to compress PostGIS geometries

 

Hi,

 

I've been experimenting with a cool technique to reduce the size of PostGIS geometries by setting insignificant bits to zero, which makes the geometry objects more compressible.

 

I described the technique in a post here, which shows some test results:

http://www.danbaston.com/posts/2018/02/15/optimizing-postgis-geometries.html

 

I'm on the fence about whether something like this has a place in the PostGIS core, but am leaning towards "yes." What do others think?

 

Dan

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180216/07a3d1c6/attachment.html>