【重新发现PostgreSQL之美】- 28 旋转门

背景

场景:

物联网、金融、游戏、社交、电商等时序场景.

挑战:

数据量超大, 即使采用列存、数据压缩方式还是很大.

PG 解决方案:

有损压缩, 自定义旋转门算法.

视频回放:

https://www.bilibili.com/video/BV1Eg411g7Sx/

https://github.com/digoal/blog/blob/master/202106/20210617_03.md#%E5%8F%82%E8%80%83 参考

https://github.com/digoal/blog/blob/master/202106/20210617_03.md#20180120180107_01md---sql%E6%B5%81%E5%BC%8F%E6%A1%88%E4%BE%8B---%E6%97%8B%E8%BD%AC%E9%97%A8%E5%8E%8B%E7%BC%A9%E5%89%8D%E5%90%8E%E8%AE%A1%E7%AE%97%E7%9B%B8%E5%85%B3%E6%BB%91%E7%AA%97%E5%A4%84%E7%90%86%E4%BE%8B%E5%AD%90 201801/20180107_01.md  《SQL流式案例 - 旋转门压缩(前后计算相关滑窗处理例子)》

https://github.com/digoal/blog/blob/master/202106/20210617_03.md#20160820160816_01md---postgresql-%E4%B8%89%E8%A7%92%E5%87%BD%E6%95%B0%E7%9A%84%E7%94%A8%E6%B3%95%E4%B8%BE%E4%BE%8B---%E5%B7%B2%E7%9F%A53%E7%82%B9%E6%B1%82%E4%BB%BB%E6%84%8F%E5%A4%B9%E8%A7%92%E6%97%8B%E8%BD%AC%E9%97%A8%E7%BB%AD 201608/20160816_01.md  《PostgreSQL 三角函数的用法举例 - 已知3点求任意夹角（旋转门续）》

https://github.com/digoal/blog/blob/master/202106/20210617_03.md#20160820160813_01md---%E6%97%8B%E8%BD%AC%E9%97%A8%E6%95%B0%E6%8D%AE%E5%8E%8B%E7%BC%A9%E7%AE%97%E6%B3%95%E5%9C%A8postgresql%E4%B8%AD%E7%9A%84%E5%AE%9E%E7%8E%B0---%E6%B5%81%E5%BC%8F%E5%8E%8B%E7%BC%A9%E5%9C%A8%E7%89%A9%E8%81%94%E7%BD%91%E7%9B%91%E6%8E%A7%E4%BC%A0%E6%84%9F%E5%99%A8%E7%AD%89%E5%9C%BA%E6%99%AF%E7%9A%84%E5%BA%94%E7%94%A8 201608/20160813_01.md  《旋转门数据压缩算法在PostgreSQL中的实现 - 流式压缩在物联网、监控、传感器等场景的应用》

https://github.com/digoal/blog/blob/master/202106/20210617_03.md#postgresql-%E8%AE%B8%E6%84%BF%E9%93%BE%E6%8E%A5 https://github.com/digoal/blog/issues/76