Should I rebuild my PostgreSQL index?
by
Laurenz Albe |
08.2025© Laurenz Albe 2025 People often ask “How can I automatically rebuild by indexes regularly?” or “When should I rebuild […]
© Laurenz Albe 2025 You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in […]
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 […]
SELECT FOR UPDATE considered harmful in PostgreSQL
by
Laurenz Albe |
06.2025© Laurenz Albe 2025 Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR […]
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 […]
Orphaned files after a PostgreSQL crash
by
Laurenz Albe |
04.2025This article describes how a PostgreSQL crash can leave some orphaned files behind and what you can do to get rid of them.
Type alignment and padding bytes: how to not waste space in PostgreSQL tables
by
Laurenz Albe |
04.2025Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
Swiss Database Synergy Day 2025: Oracle and PostgreSQL User Groups Unite
by
Laurenz Albe |
04.2025My impressions from the Swiss Database Synergy Day 2025, a conference organized by the Swiss Oracle and PostgreSQL user groups
stats_fetch_consistency: caching PostgreSQL monitoring statistics?
by
Laurenz Albe |
03.2025This article describes the little known parameter stats_fetch_consistency and its potential applications for statistics collection.
Comparison of the transaction systems of Oracle and PostgreSQL
by
Laurenz Albe |
02.2025This article offers a comparison between the transaction systems of Oracle and PostgreSQL to help you spot potential migration problems.
