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.
Dealing with the PostgreSQL error "found xmin ... from before relfrozenxid ..."
by
Laurenz Albe |
02.2025This article explains the error message "found xmin ... from before relfrozenxid ..." and shows how you can fix the problem.
commit_delay for better performance: a PostgreSQL benchmark
by
Laurenz Albe |
01.2025We benchmark the performance boost that you can get by tuning commit_delay with a workload of small transactions.
The power of open source in PostgreSQL
by
Laurenz Albe |
01.2025The power of open source helps us find out how a PostgreSQL parameter got its value. Unravel history with Git and the mailing list archive!
Dealing with trigger recursion in PostgreSQL
by
Laurenz Albe |
10.2024This article describes the problem of endless trigger recursion in PostgreSQL and shows how to deal with it and get good performance.
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.
