[pgpointcloud] Questions about indexing and querying

[Howard Butler]

Paul,

So I have endeavored to process and load the entire State of Iowa's LiDAR data into pgpointcloud using PDAL. I currently have 1.24 million patches at ~120k points per patch.  I have some questions on how to use this holding more effectively.

1) Is there an equivalent to this when the pointcloud_postgis extension is enabled? Or did I miss something? The docs don't say too much about indexing other than using the chipper to create patches.
  CREATE INDEX patches on cloud using GIS pathccolumn;

2) Does a simple count, ala "select sum(PC_NumPoints(pa)) from cloud", mean unpacking every patch all the way?

Howard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20131214/fb066194/attachment.pgp>