This article explains how PostgreSQL indexes work and their impact on query performance. It covers the types of indexes available, how data is stored, and the trade-offs in using indexes, including costs related to disk space, write operations, and memory usage.

This article explains how Floe improves the performance of geo joins by using H3 indexes. Traditional spatial joins can be slow due to their quadratic complexity, but with H3, the process becomes a fast equi-join through a filtering step that reduces the number of candidates. The result is a significant speedup in geospatial queries.