In this article, the author explains three methods to optimize the GiST index scanning to limit resource wastage in PostgreSQL.
This article discusses optimizing spatial search performance in PostgreSQL using ST_Contains and ST_Within to address the I/O amplification problem and CPU usage.
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.
This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that significantly improve query performance.
This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that can significantly improve query performance.
