Postgres

Back from pgDay Paris 2024.

A beautiful edition with high-quality content.

avatar
Adrien Nayrat

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.

avatar
Adrien Nayrat

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 …

avatar
Adrien Nayrat

GROUP BY reordering

New feature in PostgreSQL 17: GROUP BY reordering

avatar
Adrien Nayrat

PostgreSQL: TOAST compression and toast_tuple_target

Effects of TOAST and application of toast_tuple_target with JSONB

avatar
Adrien Nayrat

Partitioning use cases with PostgreSQL

Different use cases of native partioning under PostgreSQL

avatar
Adrien Nayrat

pg_sampletolog: An extension to log a sample of statements

This extension can be useful for diagnosing requests with very short execution times.

avatar
Adrien Nayrat

PostgreSQL and heap-only-tuples updates - part 3

Impact on performances

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

avatar
Adrien Nayrat

PostgreSQL and heap-only-tuples updates - part 1

How MVCC works and *heap-only-tuples* updates

avatar
Adrien Nayrat