The Curious Engineer

All blogs / Databases

PostgresAI

postgres.ai/blog

DatabasesPerformance / optimization

’20’21’22’23’24’25’26
Posts
59 from 28 Jan 2020 to 28 Oct 2026
Posting
monthly (8 in the last year)
Kind
company blog
Feed
https://postgres.ai/blog/atom.xml

2026 6

  1. Dump/restore done. Now what?
  2. DBLab 4.2: clone upgrades, simplified install, retention, and more
  3. DBLab 4.1: protection leases, Teleport, Prometheus, and more
  4. PG18 preserves planner statistics on upgrade — even from PG14
  5. How moving one word can speed up a query 10–50x
  6. The hidden cost of invalid indexes in Postgres (yes, even on Supabase/RDS/Neon)

2025 20

  1. #PostgresMarathon 2-013: Why keep your index set lean
  2. #PostgresMarathon 2-012: Ultra-fast replica creation with pgBackRest
  3. #PostgresMarathon 2-011: Prepared statements and partitioned tables — the paradox, part 3
  4. #PostgresMarathon 2-010: Prepared statements and partitioned table lock explosion, part 2
  5. #PostgresMarathon 2-009: Prepared statements and partitioned table lock explosion, part 1
  6. #PostgresMarathon 2-008: LWLock:LockManager and prepared statements
  7. #PostgresMarathon 2-007: Should we worry about pg_blocking_pids()'s observer effect?
  8. #PostgresMarathon 2-006: Mysterious max_locks_per_transaction
  9. #PostgresMarathon 2-005: More LWLock:LockManager benchmarks for Postgres 18
  10. #PostgresMarathon 2-004: Fast-path locking explained
  11. #PostgresMarathon 2-003: The roots of LWLock:LockManager
  12. #PostgresMarathon 2-002: Relation-level locks
  13. #PostgresMarathon 2-001: Lightweight and heavyweight locks
  14. Self-driving Postgres
  15. Introducing Postgres how-tos: practical guides for real-world database challenges
  16. Full-stack preview environments with DBLab 4.0: isolated databases for every pull request
  17. Postgres AI Checkup service: expert-led, AI-assisted comprehensive database health assessment
  18. SQL query toolkit in Postgres AI Console – analyze, visualize and share query plans with popular tools
  19. postgres_ai monitoring – expert-level Postgres monitoring tool for humans and AI
  20. database branching instant

2024 2

  1. AI-assisted Postgres experiment: number of partitions vs. planning time
  2. Postgres.AI Bot. Towards LLM OS for Postgres

2023 2

  1. DBLab 3.4: new name, SE installer, and lots of improvements
  2. 10 Postgres tips for beginners

2022 7

  1. Test environments that are 10x cheaper and 10x faster than RDS clones
  2. DLE 3.2: config and logs in UI, Postgres 15, AWS Marketplace version is GA
  3. Database Lab Engine for AWS Marketplace. Fast, fixed-cost branching for your Postgres is just a step away
  4. Common DB schema change mistakes
  5. DLE 3.1: pgBackRest, timezones for CLI, DLE community
  6. Progress bar for Postgres queries – let's dive deeper
  7. EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization process

2021 12

  1. DLE 3.0: UI, persistent clones, PostgreSQL 14, more
  2. Three cases against IF NOT EXISTS / IF EXISTS in Postgres DDL
  3. How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL
  4. Platform: reset clones to any data snapshot
  5. "Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues)"
  6. Zero-downtime Postgres schema migrations need this: lock_timeout and retries
  7. DLE 2.5: Better data extraction for logical mode and configuration improvements
  8. What is a slow SQL query?
  9. PostgreSQL subtransactions considered harmful
  10. Comprehensive testing covers code and data
  11. DLE 2.4: realistic DB testing in GitHub Actions; Terraform module
  12. Database Lab Engine 2.2 and Joe Bot 0.9

2020 10

  1. Database Lab Engine 2.1
  2. Database Lab Engine 2.0
  3. Database Lab Engine 2.0 beta: one config to rule them all; support for Amazon RDS
  4. plan-exporter: visualize PostgreSQL EXPLAIN data right from psql
  5. Joe 0.7.0 released! New in this release: Web UI, Channel Mapping, and new commands
  6. Joe 0.6.0 supports hypothetical indexes
  7. Database Lab Engine 0.3, supports both ZFS and LVM
  8. Joe bot, an SQL query optimization assistant, updated to version 0.5.0
  9. Database Lab Engine 0.2
  10. The first public release of Database Lab Engine