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

Helping YugabyteDB users and application builders

Databases, SQL, Oracle, AWS, YugabyteDB

YugabyteDB

Dev🔁DBA, SQL, NoSQL discussions
Help on YugabyteDB

158 posts published

18 comments written

2 tags followed

Pinned

Franck Pachot for YugabyteDB

Jul 26

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

#postgres #yugabytedb #skipscan #looseindex

4 min read

Franck Pachot for YugabyteDB

May 21

"I want to try it" 🚀 YugabyteDB at KubeCon

#kubecon #distributed #sql #yugabytedb

3 min read

Franck Pachot for YugabyteDB

Dec 17 '21

Learn how to write SQL recursive CTE in 5 steps

#postgres #yugabytedb #sql #database

47 8

6 min read

Franck Pachot for YugabyteDB

Nov 7 '21

🚀 Think about Primary Key & Indexes before anything else 🐘

#yugabytedb #database #postgres #sql

8 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

Will NoSQL Databases Replace SQL Databases in the future

This converges into Distributed SQL database. For example Yug...

Jul 26

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

That's a great question. Everything you do on production, esp...

Jul 20

find the partition key with a duplicate covering index local read

Maybe not a coincidence as this was driven by discussions wit...

Jul 14

JPA and PostgreSQL text

Thanks Andrey, yes seems it has been finally fixed in 5.6.2 ...

Jul 8

UUID/GUID, CUID & NanoID: What's The Difference?

Nice to see alternatives to balance size and performance, but...

Jun 3

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

@jamesvanderpump yes one difference with PostgreSQL is that Y...

May 10

What is a LSM Tree?

Great article ! One thing, DynamoDB uses B-Tree, not LSM Tree...

Mar 14

Stop AWS Account Hacks

Good tips for people doing a professional usage, ready to pay...

Feb 16

View all 19 comments

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 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

Franck Pachot for YugabyteDB

Jun 9

Predictable plans with pg_hint_plan full hinting

#yugabytedb #postgres #sql #hints

10 min read

Franck Pachot for YugabyteDB

Jun 7

Quickly get short stack from a YugabyteDB tserver

#yugabytedb #distributed #sql #database

2 min read

Franck Pachot for YugabyteDB

Jun 7

YugabyteDB range sharding: ASC or DESC? (Backward Scan in🚀)

#postgres #yugabytedb #sql #database

5 min read

Franck Pachot for YugabyteDB

Jun 3

ERROR: Timed out: BackfillIndex RPC

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot for YugabyteDB

Jun 3

Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

#postgres #docker #sql #database

2 min read

Franck Pachot for YugabyteDB

Jun 2

YugabyteDB Predicate Push Down

#yugabytedb #sql #distributed #database

6 min read

Franck Pachot for YugabyteDB

Jun 1

1 million rows insert

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Jun 1

tracing writes and locks in YugabyteDB

#yugabytedb #distributed #sql #lock

6 min read

Franck Pachot for YugabyteDB

May 30

Parsing YugabyteDB version()

#yugabytedb #postgres #sql #database

2 min read

Franck Pachot for YugabyteDB

May 27

pg_stat_statements in YugabyteDB

#yugabytedb #postgres #monitoring #sql

2 min read

Franck Pachot for AWS Heroes

May 27

PostgreSQL: An example of using WITH clauses to decompose the problem

#yugabytedb #postgres #sql #cte

2 min read

Franck Pachot for YugabyteDB

May 16

🐘OID <-> 🚀table_id

#yugabytedb #distributed #sql #database

4 min read

Franck Pachot for YugabyteDB

May 8

🚀 YugabyteDB on fly.io - I - yugabyted

#yugabytedb #distributed #sql #database

8 min read

Franck Pachot for YugabyteDB

May 4

docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env

#yugabytedb #postgres #docker #compose

2 min read

Franck Pachot for YugabyteDB

Apr 29

🐘🚀 Update/Insert/Soft-Delete from a JSON payload

#yugabytedb #postgres #sql #database

4 min read

Franck Pachot for YugabyteDB

Apr 29

Read Committed is a must for Postgres-compatible distributed SQL databases

#yugabytedb #postgres #sql #database

7 min read

Franck Pachot

Apr 21

cluster-aware psycopg2 🚀

#postgres #yugabytedb #python

7 min read

Franck Pachot for YugabyteDB

Apr 17

Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 4 - Explore the cost

#yugabytedb #kubernetes #oracle #cloud

3 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 3 - Run a workload

#yugabytedb #kubernetes #oracle #cloud

10 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 2 - Install from Helm chart

#yugabytedb #kubernetes #oracle #cloud

6 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 1 Create the cluster

#yugabytedb #kubernetes #oracle #cloud

4 min read

Franck Pachot

Apr 4

Index Skip Scan in YugabyteDB 🚀🐘

#postgres #yugabyted #distributed #sql

11 min read

Franck Pachot for YugabyteDB

Apr 1

Directus on YugabyteDB

#yugabytedb #nocode #distributed #sql

7 1

4 min read

Franck Pachot for AWS Heroes

Mar 19

PostgreSQL GIN + B-Tree

#postgres #gin #btree #index

6 min read

Franck Pachot for YugabyteDB

Mar 18

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

#yugabytedb #postgres #pagination #sql

10 min read

Franck Pachot for YugabyteDB

Mar 16

Serverless DB connections: Lambda to YugabyteDB 🚀

#yugabytedb #lambda #serverless #distributedsystems

17 min read

DEV Community 👩‍💻👨‍💻 is a community of 929,498 amazing developers

AWS Heroes

YugabyteDB

1 Week Community Wellness Streak

16 Week Streak

Three Year Club

8 Week Streak

4 Week Streak

Two Year Club

One Year Club

Recent comments

Will NoSQL Databases Replace SQL Databases in the future

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

find the partition key with a duplicate covering index local read

JPA and PostgreSQL text

UUID/GUID, CUID & NanoID: What's The Difference?

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

What is a LSM Tree?

Stop AWS Account Hacks