Back from pgDay Paris 2024.
A beautiful edition with high-quality content.
Adrien Nayrat
PostgreSQL DBA Freelance
For seven years, I held various positions as a systems and network engineer. And it was in 2013 that I first started working with PostgreSQL. I held positions as a consultant, trainer, and also production DBA (Doctolib, Peopledoc).
This blog is a place where I share my findings, knowledge and talks.
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 …
GROUP BY reordering
New feature in PostgreSQL 17: GROUP BY reordering
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
PostgreSQL's developments for high volumes processing
Since few years, postgreSQL received several enhancements to process high volumes databases.