#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Sign up
The home for great developer writing.
Discover the best posts from developers and engineering teams, all in one place.
Join now
→
Learn more
TOPICS
PostGIS Performance: Indexing and EXPLAIN
1
·
Crunchy Data
·
Oct. 10, 2025, 5:07 p.m.
PostGIS Performance
Postgis
postgresql
database migration
indexing
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
Azure
postgresql
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
postgresql
Discover more posts →
AUTHOR
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub
Continue with Google