PostgreSQL: How to Optimize Spatial Index-based Query Performance for Multipolygon Data

In this article, the author discusses optimizing spatial index-based query performance for multipolygon data in PostgreSQL.

Difficult Fuzzy Search: Principles of Unique GIN, GiST, SP-GiST, and RUM Indexes of PostgreSQL

This article describes how PostgreSQL helps to perform fuzzy prefix or suffix query and regexp query by using database indexes, including GIN, GiST, RUM, and other customized indexes.