About
Developer Advocate for YugabyteDB, PostgreSQL compatible Open Source distributed SQL database
Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member
Franck Pachot has presented the following presentations
pg_hint_plan - get the right plan without surprises
at
PostgresWorld Webinars 2022
some hints for full hinting
presented by Franck Pachot
video
I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and, sometimes workaround a problem in production. But hinting is not easy. Fixing the exact plan needs more than one hint. In this live demo session, we will go through understanding and examples of how to use pg_hint_plan in a predictable way. It is also a good occasion to understand the access paths, jo...
more Dev
YugabyteDB, distributed PostgreSQL: why & how?
at
PostgresWorld Webinars 2022
Reusing the PostgreSQL query layer on a distributed storage engine
presented by Franck Pachot
video
In the world of PostgreSQL compatible databases, a newcomer is YugabyteDB. Same protocol, similar open-source license, re-using postgres query layer but on a distributed storage plugged in place of heap tables and btree indexes. We will explain the reason for it, why it cannot be just an extension, and why it re-uses PostgreSQL. Similarities and differences, with an overview on the underlying t...
more Ops