Posts in Performance
Newest to oldest.
Improved Quality in OpenStreetMap Road Network for pgRouting
Published December 28, 2025, Ryan Lambert
Categories:
PostgreSQL, PostGIS, pgRouting, OpenStreetMap, Performance, PgOSM-Flex
Pre-conference Session Materials: GIS Data, Queries, and Performance
Published November 12, 2023, Ryan Lambert
Categories:
PostgreSQL, PostGIS, Performance
Postgres 15: Explain Buffer now with Temp Timings
Published June 24, 2023, Ryan Lambert
Categories:
PostgreSQL, Performance, PostGIS, OpenStreetMap, PgOSM-Flex
Track performance differences with pg_stat_statements
Published May 06, 2023, Ryan Lambert
Categories:
PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex, #PGSQLPhriday, Performance
Stubbing toes with <code>auto_explain</code>
Published December 20, 2022, Ryan Lambert
Categories:
PostgreSQL, Performance, PostGIS
Book Release! Mastering PostGIS and OpenStreetMap
Published October 01, 2022, Ryan Lambert
Categories:
PostgreSQL, PostGIS, Performance, pgRouting
H3 indexes for performance with PostGIS data
Published June 24, 2022, Ryan Lambert
Categories:
PostgreSQL, PostGIS, Performance, H3
Using Query ID in Postgres 14
Published October 15, 2021, Ryan Lambert
Categories:
PostgreSQL, Performance
PostgreSQL 13Beta3: B-Tree index deduplication
Published September 06, 2020, Ryan Lambert
Categories:
PostgreSQL, Performance
PostgreSQL: Integers, on-disk order, and performance
Published August 05, 2020, Ryan Lambert
Categories:
PostgreSQL, Performance
PostgreSQL 12 and PostGIS 3 Initial Review
Published November 13, 2019, Ryan Lambert
Categories:
PostgreSQL, PostGIS, Performance
Scaling osm2pgsql: Process and costs
Published October 15, 2019, Ryan Lambert
Categories:
PostgreSQL, OpenStreetMap, PostGIS, Performance
PostgreSQL on Raspberry Pi 4: Initial Testing
Published August 23, 2019, Ryan Lambert
Categories:
PostgreSQL, Raspberry Pi, Performance
Postgres and Pi: Use the right SD card
Published July 24, 2019, Ryan Lambert
Categories:
PostgreSQL, Raspberry Pi, Performance
PostgreSQL performance on Raspberry Pi, Reporting edition
Published April 18, 2019, Ryan Lambert
Categories:
PostgreSQL, Raspberry Pi, Performance
PostgreSQL performance on Raspberry Pi
Published April 03, 2019, Ryan Lambert
Categories:
PostgreSQL, Raspberry Pi, Performance
PostgreSQL at RustProof Labs: 2018 in Review
Published December 20, 2018, Ryan Lambert
Categories:
PostgreSQL, Performance, GIS
PostGIS: Tame your spatial data (Part 2)
Published December 01, 2018, Ryan Lambert
Categories:
Performance, PostGIS, PostgreSQL
PostGIS: Tame your spatial data (Part 1)
Published July 06, 2018, Ryan Lambert
Categories:
PostgreSQL, Performance, PostGIS
PostgreSQL 10 Parallel Queries and Performance
Published February 12, 2018, Ryan Lambert
Categories:
PostgreSQL, Performance
Database Anti-patterns: Performance Killers
Published January 28, 2018, Ryan Lambert
Categories:
PostgreSQL, MS SQL, Performance
PostgreSQL Load Testing
Published December 09, 2017, Ryan Lambert
Categories:
PostgreSQL, Performance
Testing PostgreSQL Unlogged Tables for Performance
Published July 31, 2016, Ryan Lambert
Categories:
PostgreSQL, Performance
Performance Testing RustProof Content
Published July 03, 2015, Ryan Lambert
Categories:
Performance, Blog
Mastodon