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.
Logon trigger in PostgreSQL
This post explains how this works and how such a LOGON/LOGIN trigger can be implemented and used in real life.
# GROUP BY: Fixing optimizer estimates
The more columns your GROUP BY statement contains, the more likely it is that optimizer overestimates the row count. Read more how to handle.
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!
PostgreSQL Development Introduction
In this post, you'll learn about PostgreSQL development for beginners.
Prerequisites include basic C, Git, GNU Make and SQL knowledge, and feeling comfortable working within the Linux terminal.
Quick start: How to build your first PostgreSQL container
Learn to build your first PostgreSQL container and optimize it effectively in our Docker and Kubernetes series.
Learn about the technical background of our chess tournament as part of PG Conf EU 2024.
Deploying the Zalando Kubernetes operator
Learn how to deploy the Zalando operator for PostgreSQL and ensure consistency and compliance.
Updating PostgreSQL parameters in Kubernetes and other systems
Learn about updating PostgreSQL parameters in Kubernetes and other systems, such as when changes require a restart.
Easy guide to writing PostgreSQL extensions
Learn about PostgreSQL extensions and how to write your own PostgreSQL extensions from scratch.
