Adrien Nayrat 🧗
Adrien Nayrat
(he/him)

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.

About me

I fell into PostgreSQL in 2013 and since then, this open source DBMS has never left me 😄

At Dalibo, I acquired a good knowledge of Postgres and SQL that I used in my work as a consultant. These included training, postgres tuning, participation in the PostgreSQL community (conferences, open source projects, writing articles, patches…).

At Doctolib, I acquired a strong experience in maintaining in operational conditions a high volume production with high throughput, with significant challenges in terms of service performance, security and availability: ~45,000 transactions per second on a database of more than 3.5TB with very strong growth.

Then at PeopleDoc, I joined a DBA team where my role was to make sure that production runs smoothly, communicate best practices to developers, and optimize platforms for performance. I was also involved in writing blue-green migration in as transparent a way as possible for the application and without downtime.

Since 2021 I am available for freelance missions:

  • architecture consulting
  • tuning
  • query optimization
  • database design
  • replication
  • training

I am also determined to maintain my involvement in the PostgreSQL community. Thus, you can meet me at community events (conferences, meetup…) and also on Postgres’ mailing list ;)

Here you will find articles (mostly in French but I try to translate them) about PostgreSQL. As well as the presentations that I could make during conferences.

Recents posts

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
•
Talks

How does Full Text Search works?

Full text search is a technique for finding information in a document.

BRIN indexes - How they works and usages?

This type of index looks promising for high volumetry where there is a strong correlation between the data and their location.

Contact

Contact me

I'm always interested in hearing about new projects and opportunities. Whether you're looking to collaborate, or just want to say hi, feel free to reach out!

✓ Copied to clipboard!
Send a message

Find me on