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.
Why do I have a slow COMMIT in PostgreSQL?
by
Laurenz Albe |
05.2024This article describes the possible reasons for a slow COMMIT in PostgreSQL and discusses what you can to against that.
PostgreSQL parallel query problems in JDBC and DBeaver
by
Laurenz Albe |
01.2024By default, PostgreSQL does not use parallel query when you use DBeaver. This article describes the cause and how to fix it.
(Updated 2024-12-23) Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home […]
kill -9 explained for PostgreSQL
How to kill PostgreSQL processes properly: understand how kill -9 really works vs. a normal process kill. With examples.
pg_resetwal: When to reset the WAL in PostgreSQL
How to use pg_resetwal - know the risks - When should you use this powerful tool of last resort to reset WAL? Find out now.
Memory context: private memory management in PostgreSQL
by
Laurenz Albe |
06.2023 (updated 2025-01-27) PostgreSQL uses shared memory for data shared between processes. With the exception of the dynamic shared memory […]
What is a schema in PostgreSQL?
What is a schema in PostgreSQL? Why do we need a schema and how can schemas be used to make your life easier? Let's find out.
When talking to customers, sometimes I get the question: How should PostgreSQL installations deal with huge pages and large memory […]
The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]
