Back from pgDay Paris 2024.
A beautiful edition with high-quality content.
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.
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 …
PostgreSQL: TOAST compression and toast_tuple_target
Effects of TOAST and application of toast_tuple_target with JSONB
Partitioning use cases with PostgreSQL
Different use cases of native partioning under PostgreSQL
pg_sampletolog: An extension to log a sample of statements
This extension can be useful for diagnosing requests with very short execution times.
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
PostgreSQL and heap-only-tuples updates - part 1
How MVCC works and *heap-only-tuples* updates