Back from pgDay Paris 2024.
A beautiful edition with high-quality content.
🧗
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.
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:
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.
A beautiful edition with high-quality content.
The books I suggest, from the basics to more advanced SQL, including more specific references on Postgres.
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 …
New feature in PostgreSQL 17: GROUP BY reordering
Effects of TOAST and application of toast_tuple_target with JSONB
Different use cases of native partioning under PostgreSQL
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.
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!