The home for great developer writing.

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

PostGIS Performance: Indexing and EXPLAIN

· 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

MySQL → PostgreSQL: moving a live classifieds site with ~3 minutes of downtime

özkan pakdil · Sep 18, 2026

Web Development mysql

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

Discover more posts →

AUTHOR

Advertise

Sponsor diff.blog

Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.

Become a sponsor →