Franck Pachot

Developer Advocate 🚀 YugabyteDB - open-source distributed SQL database 🔶AWS Data Hero, 🅾Oracle ACE Alumni & OCM, 🐘 PostgreSQL fan

Lausanne, Switzerland Joined on Nov 12, 2018 https://www.linkedin.com/in/franckpachot

Education

France

Work

Developer Advocate at Yugabyte

AWS Heroes

YugabyteDB

ybdemo

Lab environment for YugabyteDB demos

Shell • 11 stars

oracle-statspack-grafana

Using PostgreSQL Foreign Data Wrapper to read Oracle Statspack metrics from Grafana

PLpgSQL • 2 stars

Helping YugabyteDB users and application builders

Databases, SQL, Oracle, AWS, YugabyteDB

YugabyteDB

Dev🔁DBA, SQL, NoSQL discussions
Help on YugabyteDB

184 posts published

22 comments written

5 tags followed

Franck Pachot for YugabyteDB

Dec 7

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #sql #aggregate

3 min read

Want to connect with Franck Pachot?

Create an account to connect with Franck Pachot. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Franck Pachot for YugabyteDB

Dec 5

Index usage monitoring in YugabyteDB & PostgreSQL

#yugabytedb #postgres #index #monitoring

11 min read

Franck Pachot for YugabyteDB

Dec 2

Scalable Job Queue in SQL (YugabyteDB)

#yugabytedb #sql #queue #scalability

21 3

5 min read

Franck Pachot for YugabyteDB

Nov 30

The best indexes for an execution plan that never gets (too) wrong

#sql #database #yugabytedb #optimizer

15 min read

Franck Pachot for YugabyteDB

Nov 25

Patroni and Availability Zone failure

#postgres #ha #patroni #cloud

5 min read

Franck Pachot for YugabyteDB

Nov 22

DuckDB on YugabyteDB

#yugabytedb #olap #htap #duckdb

4 min read

Franck Pachot for YugabyteDB

Nov 20

Cross-cluster async replication with YugabyteDB xCluster

#yugabytedb #asynchronous #replication #cluster

5 min read

Franck Pachot for YugabyteDB

Nov 17

YugabyteDB auto-sharding

#yugabytedb #distributed #sql #sharding

8 min read

Franck Pachot for YugabyteDB

Nov 15

Flashback query in YugabyteDB

#yugabytedb #flashback #query #sql

6 min read

Franck Pachot for AWS Heroes

Nov 12

How far is my AWS region?

#latency #aws #region #dynamodb

4 1

7 min read

Franck Pachot for YugabyteDB

Nov 9

MariaDB Xpand Distributed MySQL

#distributed #sql #mysql #database

8 min read

Franck Pachot for YugabyteDB

Nov 8

LSM Tree, Tombstones and YugabyteDB 🚀

#yugabytedb #lsm #tombstone #wal

8 min read

Franck Pachot for YugabyteDB

Nov 8

YugabyteDB on OKE: testing batch size for bulk load

#yugabytedb #oracle #oci #kubernetes

8 min read

Franck Pachot for YugabyteDB

Nov 7

Gitpod with YugabyteDB image

#gitpod #yugabytedb #postgres #distributed

2 min read

Franck Pachot for YugabyteDB

Nov 4

Mastodon on YugabyteDB

#mastodon #yugabytedb #postgres #distributed

4 min read

Franck Pachot for YugabyteDB

Nov 1

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Nov 1

YugabyteDB cloud/region/zone

#yugabytedb #geo #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Oct 31

How to set Read Committed in YugabyteDB

#yugabytedb #postgres #isolation #sql

2 2

2 min read

Franck Pachot for YugabyteDB

Oct 21

Dirty Reads in Oracle Database (is Oracle ACID across failure?)

#acid #failure #oracle #commit

8 2

5 min read

Franck Pachot for YugabyteDB

Oct 19

YugabyteDB Skip Scan aka Loose Index Scan on compound index

#yugabytedb #postgres #sql #database

5 min read

Franck Pachot for YugabyteDB

Oct 13

Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

#sql #database #nosql #citusdb

6 min read

Franck Pachot for YugabyteDB

Oct 10

SingleStore - is there a workaround for unsupported Foreign Key?

#singlestore #foreign #key #sql

6 min read

Franck Pachot for YugabyteDB

Oct 4

pg_hint_plan: Get the right plan without surprises

#postgres #yugabytedb #hint #sql

1 min read

Franck Pachot for YugabyteDB

Oct 3

Real Application Testing on 🚀YugabyteDB 🐘pgreplay

#postgres #yugabytedb #rat #replay

4 min read

Franck Pachot for YugabyteDB

Oct 1

Moving rows from one table to the other 🐘 🚀

#postgres #yugabyte #sql #database

2 min read

Franck Pachot for YugabyteDB

Sep 30

Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain

#postgres #patroni #splitbrain #failover

5 min read

Franck Pachot

Sep 28

Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

#aws #aurora #yugabytedb #sql

7 min read

Franck Pachot for YugabyteDB

Sep 26

Declarative vs. Application side Foreign Key referential integrity

#sql #foreign #key #constraint

10 min read

Franck Pachot for YugabyteDB

Sep 17

pg_stat_statements with pg_hint_plan

#postgres #yugabytedb #sql #database

3 min read

Franck Pachot for YugabyteDB

Sep 12

EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

#yugabytedb #postgres #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Sep 6

Nakama with YugabyteDB

#yugabytedb #docker #compose #nakama

2 min read

Franck Pachot

Sep 5

SingleStore compared to YugabyteDB

#singlestore #memsql #yugabytedb #distributed

6 min read

Franck Pachot for YugabyteDB

Sep 1

Read local partition first, then global if not found locally

#sql #distributed #database #yugabytedb

7 min read

Franck Pachot for YugabyteDB

Aug 31

Fixing Docker image vulnerabilities (with centos2ol.sh)

#docker #cve #yugabytedb #centos

4 min read

Franck Pachot for YugabyteDB

Aug 30

YugabyteDB in a Micro VM with no network

#yugabytedb #microvm #firecracker #dns

3 min read

Franck Pachot for AWS Heroes

Aug 23

pg_hint_plan with subqueries

#postgres #pghintplan #sql #join

4 min read

Franck Pachot for YugabyteDB

Aug 19

Parallelizing aggregates in YugabyteDB

#yugabytedb #distributed #sql #count

4 min read

Franck Pachot for YugabyteDB

Aug 18

Fastest start of YugabyteDB for a small lab

#yugabytedb #microvm #distributed #sql

2 min read

Franck Pachot for YugabyteDB

Aug 10

Bookmarklet for YugabyteDB table's tablets

#yugabytedb #css #distrtibuted #sql

2 min read

Franck Pachot for YugabyteDB

Jul 31

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

#yugabytedb #postgres #mongodb #sql

4 min read

Franck Pachot for YugabyteDB

Jul 26

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

#postgres #yugabytedb #skipscan #looseindex

5 min read

Franck Pachot for YugabyteDB

Jul 25

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot

Jul 25

Default tablet splitting in YugabyteDB 🚀

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Jul 20

📜 select * from 🚀 logfile with 🐘 file_fdw

#yugabytedb #troubleshooting #logfile #fdw

2 min read

Franck Pachot for YugabyteDB

Jul 20

YugabyteDB cardinality estimation in the absence of ANALYZE statistics

#yugabytedb #optimizer #planner #dynamodb

9 min read

Franck Pachot for AWS Heroes

Jul 18

IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

#yugabytedb #iot #postgres #distributed

4 min read

Franck Pachot for YugabyteDB

Jul 18

⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

#yugabytedb #postgres #troubleshooting #strace

6 3

6 min read

Franck Pachot

Jul 15

🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

#yugabytedb #troubleshooting #distributed #database

5 min read

Franck Pachot for YugabyteDB

Jul 13

access the local partition only in 🚀 YugabyteDB geo-partitioned tables

#yugabyted #distributed #sql #database

4 min read

Franck Pachot for YugabyteDB

Jul 13

find the partition key with a duplicate covering index local read

#yugabytedb #distributed #sql #database

9 2

8 min read

Franck Pachot for YugabyteDB

Jul 7

JPA and PostgreSQL text

#postgres #jpa #hibernate #yugabytedb

9 3

3 min read

Franck Pachot

Jul 5

The YugabyteDB configuration parameters (GFLAGs and GUCs)

#yugabytedb #postgres #distributed #database

5 min read

Franck Pachot for YugabyteDB

Jul 4

Optimizing Nested Loop joins on YugabyteDB with jOOQ

#yugabytedb #jooq #sql #distributed

4 min read

Franck Pachot for YugabyteDB

Jun 30

geo-distribution with 🚀 YugabyteDB tablespaces

#yugabytedb #distributed #postgres #sql

4 min read

Franck Pachot for YugabyteDB

Jun 27

Local reads from 🚀YugabyteDB Read Replicas

#yugabytedb #distributed #postgres #sql

7 min read

Franck Pachot for YugabyteDB

Jun 27

Local reads from 🚀YugabyteDB raft followers

#yugabytedb #distributed #postgres #sql

10 1

6 min read

Franck Pachot for YugabyteDB

Jun 22

🚀 hash+hash partitioning+sharding

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for YugabyteDB

Jun 15

(beta) yugabyted GUI

#yugabytedb #cloud #gui #database

2 min read

Franck Pachot for YugabyteDB

Jun 14

PITR snapshot: an easy flashback / backtrack for application releases

#yugabytedb #cicd #snapshot #database

7 min read

Franck Pachot for YugabyteDB

Jun 12

Nested Loop performance in YugabyteDB

#yugabytedb #distributed #sql #database

12 min read

DEV Community 👩‍💻👨‍💻 is a community of 968,547 amazing developers

AWS Heroes

YugabyteDB

Four Year Club

1 Week Community Wellness Streak

16 Week Streak

Three Year Club

8 Week Streak

4 Week Streak

Two Year Club

One Year Club

Want to connect with Franck Pachot?