【PostgreSQL】资料索引（来源：德哥）

 

PostgreSQL 多应用场景实践 - 沙箱实验

https://github.com/digoal/blog/blob/master/201805/20180524_02.md

 

 

 

---

 

一、GIS

《如何建立GIS测试环境 - 将openstreetmap的样本数据导入PostgreSQL PostGIS库》
https://github.com/digoal/blog/blob/master/201609/20160906_01.md
《geoip - Geolocation using GeoIP》
https://github.com/digoal/blog/blob/master/201504/20150427_01.md
《GIS附近查找性能优化 - PostGIS long lat geometry distance search tuning using gist knn function》
https://github.com/digoal/blog/blob/master/201308/20130806_01.md
《路径规划应用 pgRouting 实践与开放地图导入 - Openstreetmap PBF》
https://github.com/digoal/blog/blob/master/201508/20150813_03.md
《PostgreSQL 百亿地理位置数据 近邻查询性能》
https://github.com/digoal/blog/blob/master/201601/20160119_01.md
《PostgreSQL 在3D 数据内容管理中的应用》
https://github.com/digoal/blog/blob/master/201603/20160331_01.md
《PostgreSQL 内核扩展之 - 管理十亿级3D扫描数据(基于Lidar产生的point cloud数据)》
https://github.com/digoal/blog/blob/master/201606/20160629_01.md
《聊一聊双十一背后的技术 - 物流、动态路径规划》
https://github.com/digoal/blog/blob/master/201611/20161114_01.md
《聊一聊双十一背后的技术 - 分词和搜索》
https://github.com/digoal/blog/blob/master/201611/20161115_01.md
《(AR虚拟现实)红包 技术思考 - GIS与图像识别的完美结合》
https://github.com/digoal/blog/blob/master/201701/20170113_01.md
《[转载]postgres+socket.io+nodejs实时地图应用实践》
https://github.com/digoal/blog/blob/master/201701/20170113_02.md
《PostGIS 地理信息、栅格数据 多核并行处理(st_memunion, st_union)》
https://github.com/digoal/blog/blob/master/201703/20170307_03.md
《开放地图OpenStreetMap与PostGIS的三生三世十里桃花》
https://github.com/digoal/blog/blob/master/201703/20170327_01.md
《PostGIS 多点几何类型 空字符构造异常CASE - parse error - invalid geometry (lwgeom_pg.c:96)》
https://github.com/digoal/blog/blob/master/201703/20170328_03.md
《视觉挖掘与PostGIS空间数据库的完美邂逅 - 广告营销\圈人》
https://github.com/digoal/blog/blob/master/201703/20170328_04.md
《奔跑吧，大屏 - 时间+空间 实时四维数据透视》
https://github.com/digoal/blog/blob/master/201704/20170413_02.md
《PostgreSQL 物流轨迹系统数据库需求分析与设计 - 包裹侠实时跟踪与召回》
https://github.com/digoal/blog/blob/master/201704/20170418_01.md
《geohash vs PostGIS》
https://github.com/digoal/blog/blob/master/201704/20170422_01.md
《无人驾驶背后的技术 - PostGIS点云(pointcloud)应用 - 1》
https://github.com/digoal/blog/blob/master/201705/20170519_02.md
《无人驾驶背后的技术 - PostGIS点云(pointcloud)应用 - 2》
https://github.com/digoal/blog/blob/master/201705/20170523_01.md
《空间复合索引加速空间搜索》
https://github.com/digoal/blog/blob/master/201706/20170620_01.md
《PostGIS 坐标转换(SRID)的边界问题引发的专业知识 - ST_Transform》
https://github.com/digoal/blog/blob/master/201706/20170622_01.md
《PostgreSQL\GPDB 毫秒级海量时空数据透视 典型案例分享》
《SRID (空间引用识别号, 坐标系)》
https://github.com/digoal/blog/blob/master/201707/20170718_01.md
《时间、空间、对象多维属性 海量数据任意多维 高效检索 - 阿里云RDS PostgreSQL最佳实践》
https://github.com/digoal/blog/blob/master/201707/20170722_01.md
《车联网案例，轨迹清洗 - 阿里云RDS PostgreSQL最佳实践 - 窗口函数》
https://github.com/digoal/blog/blob/master/201707/20170722_02.md
《PostGIS 空间数据学习建议》
https://github.com/digoal/blog/blob/master/201708/20170809_01.md
《PostGIS空间索引(GiST、BRIN、R-Tree)选择、优化 - 阿里云RDS PostgreSQL最佳实践》
https://github.com/digoal/blog/blob/master/201708/20170820_01.md
《Greenplum 空间(GIS)数据检索 b-tree & GiST 索引实践 - 阿里云HybridDB for PostgreSQL最佳实践》
https://github.com/digoal/blog/blob/master/201708/20170824_02.md
《通过空间思想理解GiST索引的构造》
https://github.com/digoal/blog/blob/master/201708/20170825_01.md
《地理坐标系（球面坐标系）和投影坐标系（平面坐标系）》
https://github.com/digoal/blog/blob/master/201709/20170911_01.md
《PostGIS 点面叠加视觉判断输出》
https://github.com/digoal/blog/blob/master/201709/20170914_01.md
《海量用户实时定位和圈人 - 团圆社会公益系统(位置寻人\圈人)》
https://github.com/digoal/blog/blob/master/201709/20170915_01.md
《PostgreSQL 10 + PostGIS + Sharding(pg_pathman) + MySQL(fdw外部表) on ECS 部署指南(适合新用户) - 珍藏级》
https://github.com/digoal/blog/blob/master/201710/20171018_01.md
《PostGIS 距离计算建议 - 投影 与 球 坐标系, geometry 与 geography 类型》
https://github.com/digoal/blog/blob/master/201710/20171018_02.md
《PostgreSQL + PostGIS + SFCGAL 优雅的处理3D数据》
https://github.com/digoal/blog/blob/master/201710/20171026_02.md
《PostgreSQL 电子围栏的应用场景和性能(大疆、共享设备、菜鸟。。。)》
https://github.com/digoal/blog/blob/master/201710/20171031_01.md
《GIS术语 - POI、AOI、LOI、路径、轨迹》
https://github.com/digoal/blog/blob/master/201712/20171204_01.md
《PostgreSQL 实时位置跟踪+轨迹分析系统实践 - 单机顶千亿轨迹/天》
https://github.com/digoal/blog/blob/master/201712/20171231_01.md
《PostgreSQL 3D City 应用》
https://github.com/digoal/blog/blob/master/201801/20180103_01.md
《OSM(OpenStreetMap) poi、路网 数据导入 PostgreSQL》
https://github.com/digoal/blog/blob/master/201801/20180118_01.md
《如何将谷歌地球(google earth) 的数据导入 PostgreSQL》
https://github.com/digoal/blog/blob/master/201801/20180118_02.md
《PostgreSQL 时序数据库插件 timescaleDB 部署实践(含例子 纽约TAXI数据透视分析) - PostGIS + timescaleDB => PG时空数据库》
https://github.com/digoal/blog/blob/master/201801/20180129_01.md
《PostgreSQL raster(栅格数据) st_value 优化举例》
https://github.com/digoal/blog/blob/master/201802/20180226_06.md
滴滴打车派单系统思考 数据库设计与实现 - 每月投入6140元, 1天最多可盈利117亿
https://github.com/digoal/blog/blob/master/201804/20180414_03.md
《PostgreSQL 滴滴派单 高峰区域集中打车冲突优化1 - 宇宙大爆炸理论与PostgreSQL实践》
https://github.com/digoal/blog/blob/master/201804/20180416_02.md
《为什么geometry+GIST 比 geohash+BTREE更适合空间搜索 - 多出的不仅仅是20倍性能提升》
https://github.com/digoal/blog/blob/master/201804/20180417_01.md
《PostgreSQL PostGIS 的5种空间距离排序(knn)算法》
https://github.com/digoal/blog/blob/master/201806/20180605_02.md
《PostgreSQL + PostGIS 时态分析》
https://github.com/digoal/blog/blob/master/201806/20180607_01.md
《PostgreSQL 空间位置(geometry 经纬、点、线、面...)、行政地址(门牌、商圈、行政区...) 相互转换方法》
https://github.com/digoal/blog/blob/master/201807/20180725_01.md
《PostgreSQL 生成空间热力图》
https://github.com/digoal/blog/blob/master/201807/20180725_02.md
《PostgreSQL PostGIS 空间数据约束使用》
https://github.com/digoal/blog/blob/master/201808/20180808_01.md
《PostgreSQL PostGIS point join polygon (by ST_xxxx) - pglz_decompress 性能优化》
https://github.com/digoal/blog/blob/master/201810/20181001_02.md
《PostgreSQL IoT，车联网 - 实时轨迹、行程实践 1》
https://github.com/digoal/blog/blob/master/201812/20181207_01.md
《PostgreSQL IoT，车联网 - 实时轨迹、行程实践 2 - (含index only scan类聚簇表效果)》
https://github.com/digoal/blog/blob/master/201812/20181209_01.md
《地理位置画像、连锁店圈人、地理围栏圈人、多地圈选、multi-polygon圈选、多点圈选》
https://github.com/digoal/blog/blob/master/201901/20190116_01.md
《PostgreSQL PostGIS 性能提升 - by new GEOS代码》
https://github.com/digoal/blog/blob/master/201903/20190310_01.md

 二、IOT

《PostgreSQL 黑科技 range 类型及 gist index 助力物联网(IoT)》
https://github.com/digoal/blog/blob/master/201205/20120517_01.md
《"物联网"流式处理应用 - 用PostgreSQL实时处理(万亿每天)》
https://github.com/digoal/blog/blob/master/201512/20151215_01.md
《PostgreSQL 物联网黑科技 - 瘦身几百倍的索引(BRIN index)》
https://github.com/digoal/blog/blob/master/201604/20160414_01.md
《旋转门数据压缩算法在PostgreSQL中的实现 - 流式压缩在物联网、监控、传感器等场景的应用》
https://github.com/digoal/blog/blob/master/201608/20160813_01.md
《(流式、lambda、触发器)实时处理大比拼 - 物联网(IoT)\金融,时序处理最佳实践》
https://github.com/digoal/blog/blob/master/201705/20170518_01.md
块级(ctid)扫描在IoT(物联网)极限写和消费读并存场景的应用
https://github.com/digoal/blog/blob/master/201706/20170607_01.md
《泛电网系统 海量实时计算+OLTP+OLAP DB设计 - 阿里云(RDS、HybridDB) for PostgreSQL最佳实践》
https://github.com/digoal/blog/blob/master/201708/20170826_01.md
《用PostgreSQL 处理 指纹 数据》
https://github.com/digoal/blog/blob/master/201801/20180119_02.md
《[未完待续] PostgreSQL + timescaleDB + Prometheus 物联网时序数据监控组合》
https://github.com/digoal/blog/blob/master/201804/20180420_01.md

 

三、AI

《在PostgreSQL中用线性回归分析(linear regression) - 实现数据预测》
https://github.com/digoal/blog/blob/master/201503/20150303_01.md
《弱水三千,只取一瓢,当图像搜索遇见PostgreSQL(Haar wavelet)》
https://github.com/digoal/blog/blob/master/201607/20160726_01.md
《脑王水哥王昱珩惜败人工智能, 这不可能. - 图像识别到底是什么鬼》
https://github.com/digoal/blog/blob/master/201701/20170122_01.md

 

四、NLP

《PostgreSQL 使用 nlpbamboo chinesecfg 中文分词》
https://github.com/digoal/blog/blob/master/201206/20120621_01.md
《PostgreSQL chinese full text search 中文全文检索》
https://github.com/digoal/blog/blob/master/201403/20140324_01.md
《NLPIR 分词准确率接近98.23%》
https://github.com/digoal/blog/blob/master/201508/20150821_01.md
《PostgreSQL Greenplum 结巴分词(by plpython)》
https://github.com/digoal/blog/blob/master/201508/20150824_01.md

 

五、图数据库

《图数据库 CayLey + PostgreSQL》
https://github.com/digoal/blog/blob/master/201601/20160118_02.md
《金融风控、公安刑侦、社会关系、人脉分析等需求分析与数据库实现 - PostgreSQL图数据库场景应用》
https://github.com/digoal/blog/blob/master/201612/20161213_01.md
《PostgreSQL 图式搜索(graph search)实践 - 百亿级图谱，毫秒响应》
https://github.com/digoal/blog/blob/master/201801/20180102_04.md

 

六、推荐系统

《恭迎万亿级营销(圈人)潇洒的迈入毫秒时代 - 万亿user_tags级实时推荐系统数据库设计》
https://github.com/digoal/blog/blob/master/201612/20161225_01.md

 

七、其他知识

201106/20110612_01.md 《行列变换 - Use tablefunc complete row & column cross display in PostgreSQL》
https://github.com/digoal/blog/blob/master/201106/20110612_01.md