Semantic Search in PostgreSQL: An Overview
PostgreSQL enhances search capabilities with extensions like pgvector, enabling advanced semantic search. Find out more in this blog posting.
Debugging PostgreSQL more easily
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.
PostgreSQL: 1 trillion rows in Citus
"PostgreSQL scales" - what does it mean? Find out what 1 trillion rows in Citus is all about in this blog post.
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.
PostgreSQL: To normalize or not to normalize?
In this blog posting you can read more about one of the fundamental principles in the realm of databases: "Normalization".
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.
End of the road for PostgreSQL streaming replication?
In this blog posting you can read more about PostgreSQL streaming replication. It tells you about how to deal with it and how it works.
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.
