Avatar

Adrien Nayrat

PostgreSQL DBA & Freelance

DBA @Peopledoc

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.

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

Since 2021 I am also 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

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

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.

Events

Contact