Understanding LATERAL joins in PostgreSQL
LATERAL joins are extremely useful & can be utilized in many cases to speed up operations, or to simply make code a lot easier to understand.
Creating and refreshing materialized views in PostgreSQL
A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?
For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]
Disabling autocommit in PostgreSQL can damage your health
by
Laurenz Albe |
06.2021 When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]
How to interpret PostgreSQL EXPLAIN ANALYZE output
by
Laurenz Albe |
05.2021 UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
by
Laurenz Albe |
05.2021 UPDATED 14.05.2022: Sometimes customers ask me about the best choice for auto-generated primary keys. In this article, I'll explore […]
What to return from a PostgreSQL row level trigger?
by
Laurenz Albe |
04.2021 In this article, I'll talk about row level triggers, which are the most frequently used kind of triggers. I […]
Golden Proportions in PostgreSQL
Learn how PostgreSQL can help with basic calculations regarding golden proportions. Do mathematics in your database development work.
Tips and tricks to kick-start the Postgres year 2021
Start learning some new Postgres stuff again in 2021 and find some tips: Partial indexing, estimating average row size and more.
Is UPDATE the same as DELETE + INSERT in PostgreSQL?
by
Laurenz Albe |
12.2020 Introduction We know that PostgreSQL does not update a table row in place. Rather, it writes a new version […]
