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:
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 ;)
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
How MVCC works and heap-only-tuples updates
Since few years, postgreSQL received several enhancements to process high volumes databases.
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.