SELECT FOR UPDATE considered harmful in PostgreSQL
by
Laurenz Albe |
06.2025© Laurenz Albe 2025 Recently, while investigating a deadlock for a customer, I was again reminded how harmful SELECT FOR […]
The Fun of Open Source: Roman Numerals in PostgreSQL
by
Laurenz Albe |
06.2025© Laurenz Albe 2025 Recently, I wrote about the power of open source. Now, power is good and important, but […]
Type alignment and padding bytes: how to not waste space in PostgreSQL tables
by
Laurenz Albe |
04.2025Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
pgai: Importing Wikipedia into PostgreSQL
In this blog posting you can read more about how we can import Wikipedia into PostgreSQL and make use of it by using pgai.
Using pgvector for timeseries data
pgvector is a popular PostgreSQL extension for semantic search, facilitating discussions on AI and related topics.
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.
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.
