In this article, the author discusses spatiotemporal object selection and data pivoting and extensively compares PostgreSQL 10 and Greenplum in this respect with example code.
In this article, the author discusses performance issues in spatial search and accelerating spatial search using GiST and B-tree spatial composite indexes.
This article discusses Geohash and PostGIS in detail and compares them to explain their limitations and advantages in handling spatial data.
