Franck Pachot
Developer Advocate at Yugabyte
Developer Advocate for YugabyteDB, PostgreSQL compatible Open Source distributed SQL database
Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member
Upcoming presentations
No upcoming presentations...
Past presentations
pg_hint_plan - get the right plan without surprises
some hints for full hinting
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...
YugabyteDB, distributed PostgreSQL: why & how?
Reusing the PostgreSQL query layer on a distributed storage engine
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...