~postgresweekly | Bookmarks (5)

How to Automate Postgres Index Selection Using the CP-SAT Solver — Learn about the Constraint Programming model powering pganalyze Index Advisor 3.0. This technical deep dive (56min video) with Lukas Fittl & Philippe Olivier is a behind-the-scenes look at using the CP-SAT solver for recommending Postgres indexes.

pganalyze Index Advisor 3.0: Workload-Aware Index Suggestions — Launched last week, the new advisor finds missing indexes for each table, detects indexes that would block HOT Updates, lets you drill-down to see all considered indexes, and more. Powered by the constraint programming model introduced at PGCon 2023.

eBook: Tuning Autovacuum for Best Postgres Performance — Learn about tuning settings for scheduling and performance, reducing autovacuum overhead during business hours, the xmin horizon and how it blocks vacuums, why to avoid anti-wraparound vacuums and how to reduce bloat by tuning dead tuple thresholds.

Introducing pg_query for Postgres 16 — pg_query is a long standing standalone library (with Ruby, Rust and Go bindings) for turning SQL queries into parse trees. This new version is based on Postgres 16, supports SQL/JSON, and now works on Windows too.

▶  Waiting for Postgres 17: Incremental Base Backups — Walking through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. (6-minute video with transcript.)