How to handle "database is not accepting commands"
by
Laurenz Albe |
09.2025© Laurenz Albe 2025 If you ever get the error message “database is not accepting commands”, you are dangerously close […]
I recently helped a customer with a slow query. Eventually, an ANALYZE on a partitioned table was enough to fix […]
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 […]
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 […]
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.
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.
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.
What you should know about Linux memory overcommit in PostgreSQL
by
Laurenz Albe |
07.2024Understand why and how to disable memory overcommit to make PostgreSQL run reliably on Linux, including implications for containerization.
Syslog logging with journald in PostgreSQL
by
Laurenz Albe |
04.2024This article explains how to configure syslog logging in PostgreSQL and shows how to view and manage the log with journald.
What you should know about PostgreSQL minor upgrades
by
Laurenz Albe |
12.2023© Laurenz Albe 2023 The PostgreSQL documentation is rather terse on the subject of minor upgrade. The reason is probably […]
