背景
PolarDB 的云原生存算分离架构, 具备低廉的数据存储、高效扩展弹性、高速多机并行计算能力、高速数据搜索和处理; PolarDB与计算算法结合, 将实现双剑合璧, 推动业务数据的价值产出, 将数据变成生产力.
本文将介绍使用 PolarDB 开源版 部署 pgpointcloud 支撑激光点云数据的高速存储、压缩、高效精确提取
测试环境为macOS+docker, PolarDB部署请参考如何用 PolarDB 证明巴菲特的投资理念 - 包括PolarDB简单部署。
pgpointcloud 的特性
pgPointcloud - A PostgreSQL extension for storing point cloud (LIDAR) data
LIDAR sensors quickly produce millions of points with large numbers of variables measured on each point. The challenge for a point cloud database extension is efficiently storing this data while allowing high fidelity access to the many variables stored.
部署pgpointcloud on PolarDB
wget https://github.com/pgpointcloud/pointcloud/archive/refs/tags/v1.2.4.tar.gz
tar -zxvf v1.2.4.tar.gz
cd pointcloud-1.2.4/
./autogen.sh
./configure
make -j 4
sudo make install [postgres@1373488a35ab pointcloud-1.2.4]$ psql
psql (11.9)
Type "help" for help.
postgres=# create extension postgis;
CREATE EXTENSION
postgres=# create extension pointcloud;
CREATE EXTENSION
postgres=# create extension pointcloud_postgis ;
CREATE EXTENSION 详细用法请参考:
