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:
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 ;)
Effects of TOAST and application of toast_tuple_target with JSONB
Different use cases of native partioning under PostgreSQL
This extension can be useful for diagnosing requests with very short execution times.
Impact on performances
When postgres do not use heap-only-tuple updates and introduction to the new feature in v11
Full text search is a technique for finding information in a document.
This type of index looks promising for high volumetry where there is a strong correlation between the data and their location.