Postgres

Back from pgDay Paris 2024.
A beautiful edition with high-quality content.
18 Mar 2024 5 min read Postgres
Recommended resources to improve your knowledge of Databases and PostgreSQL
The books I suggest, from the basics to more advanced SQL, including more specific references on Postgres.
12 Feb 2024 4 min read Postgres
Postgres again elected DBMS of the Year in 2023, but I'm worried
Once again, Postgres has been elected DBMS of the Year by DB-Engines. Although this is only a ranking, it gives a trend. It has also been recognized for several years in Stackoverflow surveys : Most popular Databases.
5 Feb 2024 12 min read Postgres
GROUP BY reordering
New feature in PostgreSQL 17: GROUP BY reordering
Last updated on 29 Jan 2024 5 min read Postgres
PostgreSQL: TOAST compression and toast_tuple_target
Effects of TOAST and application of toast_tuple_target with JSONB
14 Feb 2022 11 min read Postgres
Partitioning use cases with PostgreSQL
Different use cases of native partioning under PostgreSQL
1 Sep 2021 11 min read Postgres
pg_sampletolog: An extension to log a sample of statements
This extension can be useful for diagnosing requests with very short execution times.
28 Jan 2019 5 min read Postgres
PostgreSQL and heap-only-tuples updates - part 3
Impact on performances
26 Nov 2018 7 min read Postgres
PostgreSQL and heap-only-tuples updates - part 2
When postgres do not use heap-only-tuple updates and introduction to the new feature in v11
19 Nov 2018 7 min read Postgres
PostgreSQL and heap-only-tuples updates - part 1
How MVCC works and heap-only-tuples updates
12 Nov 2018 9 min read Postgres