×
GiST index

Optimize Spatial Searches in PostgreSQL Using ST_Contains and ST_Within

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.

Comparison Between PostgreSQL 10 and Greenplum in Spatiotemporal Object Selection and Data Pivoting

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.

Range Types in PostgreSQL and GiST Indexes Increases Speed of MySQL Index Combine Queries

This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that significantly improve query performance.

Range Types in PostgreSQL and GiST Indexes

This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that can significantly improve query performance.