Franck Pachot
🥑 Developer Advocate at 🍃 MongoDB, 🔶 AWS Data Hero, 🐘 PostgreSQL fan,▝▞ YugabyteDB expert, 🅾️ Oracle Certified Master, and 💚 loving all databases 🛢️
Isolation levels in YugabyteDB
Transaction Internals: Fast Path vs Multi-Shard
Technical Comparison of YugabyteDB with Oracle and PostgreSQL
pg_hint_plan - get the right plan without surprises
Distributed Loose Index Scan (aka Skip/Jump/Hybrid Scan). An example with time series in YugabyteDB
Testing ChatGPT to generate SQL
Use The Index Luke on YugabyteDB - Episode 05
Use The Index Luke on YugabyteDB - Episode 04
Use The Index Luke on YugabyteDB - Episode 03
Uses The Index Like on YugabyteDB - Episode 02
Use The Index Luke on YugabyteDB - Episode 01
Demo du meetup DevOps Genève avec YugabyteDB sur Kubernetes
LinuxSillyMetrics 5 - 2021 09 03 15 26 01 buffered
LinuxSillyMetrics 6 - 2021 09 03 15 30 39 loadavg
LinuxSillyMetrics 4 - 2021 09 03 15 23 55 libaio
LinuxSillyMetrics 3 - 2021 09 03 15 10 41 strace bc
LinuxSillyMetrics 7 - 2021 09 03 15 40 41 free
LinuxSillyMetrics 8 - 2021 09 03 15 44 43 no idea
LinuxSillyMetrics 2 - 2021 09 03 15 05 46 Look at wio
LinuxSillyMetrics 1 - 2021 09 03 15 00 12 Look at top
SQL primary key, surrogate key, composite keys, foreign keys...
Wait events & DB Time ( Franck Pachot at POUG Workshop)
SQL101 SQL Basics (NoSQL to SQL) all on Autonomous Database
Franck Pachot #KnowSQL presentation at DOAG2020
pgio / pg_hint_plan / pg_sentinel
20 features you will miss if you leave Oracle Database (the demos)
From Transportable Tablespaces to Pluggable Databases
Join Methods: Nested Loop, Hash, Sort, Merge, Adaptive
Créer une base Oracle sur le Cloud trial
TmuxForDemos