[pgpointcloud] uncompressed pointcloud size

Sandro Santilli strk at keybit.net
Mon Feb 2 08:47:33 PST 2015


On Mon, Feb 02, 2015 at 06:26:14AM -0800, Paul Ramsey wrote:
> Not a bug.
> The pcpatch type is declared with storage ‘external’, so pgsql doesn’t attempt to compress it at all.
> 65535 * 8 * 8 = 4194487, raw, uncompressed data.
> The geometry type is declared with storage ‘main’, which does allow pgsql to compress, if the size exceeds a page. So you’re seeing the post-zlib size when you run pg_column_size.

Thanks, everything makes sense now :)
I've experimented with changing the storage and indeed uncompressed/external
is now comparable between geometry and pcpatch ( the former being actually
bigger, probably due to SRID and type being replicated in each component
point ). Now I wanted to try different kind of compressions but I could
not find any function to change the pointcloud_format id in a pcpatch type,
is there any such function ? Simply casting to a different type fails
with an error (pcid not consistent).

--strk;


More information about the pgpointcloud mailing list