Avatar

Adrien Nayrat

PostgreSQL DBA Freelance

Member of PostgreSQL Europe

Presentation

I fell into PostgreSQL in 2014 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 (but not only 😄). As well as the presentations that I could make during conferences. Feel free to open an issue on github ;)

Interests

  • PostgreSQL
  • Open Source
  • Linux
  • Social Science
  • Social and Solidarity Economy

Recent Posts

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

Events

Contact