The home for great developer writing.

We surface the best developer writing from thousands of independent blogs, updated daily.

PostGIS Performance: Indexing and EXPLAIN

1 · Crunchy Data · Oct. 10, 2025, 5:07 p.m.

PostGIS Performance Postgis postgresql indexing database migration

Summary

This blog post provides instructions and tips for using logical replication to migrate Postgres databases to new platforms or hosts, focusing on performance aspects related to PostGIS and indexing.

Read full post on www.crunchydata.com →

MORE POSTS LIKE THIS

azure: [In preview] Public Preview: Migrating from virtual network-integrated to Private Endpoint–capable network configuration

Sujith Quintelier · Apr 23, 2026

Networking Azure

Indexing Your Way into a Performance Bottleneck

Timescale · Apr 10, 2026

PostgreSQL Performance PostgreSQL Tips

Automating RDS Postgres to Aurora Postgres Migration

Netflix, Inc. · Feb 12, 2026

postgresql aurora

PostgreSQL major version upgrade on Alpine Linux, redux

Thiago Perrotta · Jan 16, 2026

Alpine Linux Dev

Postgres Scan Types in EXPLAIN Plans

Crunchy Data · Dec 4, 2025

Production Postgres postgresql

PostGIS: A powerful geospatial extension for PostgreSQL

Red Hat · Oct 2, 2025

Postgis RHEL

Discover more posts →

AUTHOR