Preserve optimizer statistics during major upgrades with PostgreSQL v18
by
Laurenz Albe |
06.2025© Laurenz Albe 2025 Everybody wants good performance. When it comes to the execution of SQL statements, accurate optimizer statistics […]
The Fun of Open Source: Roman Numerals in PostgreSQL
by
Laurenz Albe |
06.2025© Laurenz Albe 2025 Recently, I wrote about the power of open source. Now, power is good and important, but […]
What's so great about PostgreSQL v17?
by
Laurenz Albe |
10.2024PostgreSQL v17 has been released. If the list of new features does not inspire you, this article will try to change your mind.
Introducing pg_timetable v5.6: delayed chains and error handling
We're excited to unveil pg_timetable v5.6, a significant release that takes your PostgreSQL job scheduling to a new level. In […]
PostgreSQL v16 contains many new features and enhancements. Here are PG v16's 14 best new features: Everybody's favorite: You no longer […]
LZ4 and ZSTD pg_dump compression in PostgreSQL 16
LZ4 and ZSTD pg_dump compression I wrote a "pg_dump compression specifications in PostgreSQL 16" post a while ago. Frankly speaking, […]
Underscores in numeric constants in PostgreSQL 16
SQL and numeric constants NEW in PostgreSQL 16 - support for underscores in integer and numeric constants! I already wrote […]
New old "debug_parallel_query" setting in PostgreSQL 16
Naming variables Why will force_parallel_mode - the runtime option be renamed to debug_parallel_query in PostgreSQL 16? Proper variable and function […]
pg_timetable v5.3 is out!
Our team is proud to introduce a new pg_timetable v5.3 release! This time we focused solely on implementing new features […]
Go & PostgreSQL: FOSDEM 2023 talk
Intro On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during […]
