# 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.
Learn about the technical background of our chess tournament as part of PG Conf EU 2024.
Why "SELECT * FROM table" is NOT a read
People tend to think that a SELECT-operation is always a read. This might look obvious and make sense but does it actually hold true?
Making the PostgreSQL visibility map visible
by
Laurenz Albe |
06.2024This article explains how to examine the PostgreSQL visibility map and showcases performance improvements added in recent releases.
Foreign keys in PostgreSQL: Circular dependencies
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".
TDE: A dive into encrypted data
In this article we will tell you how you can find out, if your TDE works and if files on disk are encrypted.
ERROR: current transaction is aborted in PostgreSQL
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.
Kill long running queries in PostgreSQL
How to detect and terminate long running queries in PostgreSQL using two different methods. Also: How to automatically kill slow queries.
"hired" vs. "fired" - fuzzy search in PostgreSQL
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
Exclusion constraints in PostgreSQL and a tricky problem
Exclusion constraints in PostgreSQL are complex, see this use case using WHERE STATUS. There are limits to what exclusion constraints can do.
