Franck Pachot

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

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

Education

France

Work

Developer Advocate at Yugabyte

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

2 min read

Franck Pachot for YugabyteDB

Dec 17 '21

Learn how to write SQL recursive CTE in 5 steps

#postgres #yugabytedb #sql #database

46 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 for YugabyteDB

Jul 31

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

#yugabytedb #postgres #mongodb #sql

4 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 local read in 🚀 YugabyteDB geo-partitioned tables

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

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 local read in 🚀 YugabyteDB geo-partitioned tables

#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

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?

#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

Franck Pachot for AWS Heroes

Mar 13

PostgreSQL index partition in same tablespace as table

#postgres #tablespace #partition #index

7 min read

Franck Pachot for YugabyteDB

Mar 10

Avoiding hotspots in pgbench on 🐘or🚀

#postgres #yugabytedb #sql #database

9 min read

Franck Pachot for AWS Heroes

Mar 4

PostgreSQL on ARM: default page size matters

#postgres #graviton #arm #pagesize

9 min read

Franck Pachot for YugabyteDB

Mar 1

YugabyteDB on Public network 🚀🌐

#yugabytedb #distributed #sql #database

7 min read

Franck Pachot

Mar 1

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

#postgres #yugabytedb #sql #database

4 min read

Franck Pachot for YugabyteDB

Feb 25

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

#yugabytedb #sql #database #postgres

7 2

7 min read

Franck Pachot for YugabyteDB

Feb 23

Reference Tables as duplicate covering indexes

#yugabytedb #distributed #sql #database

16 min read

Franck Pachot for AWS Heroes

Feb 23

🔶🚀 YugabyteDB on Amazon EKS

#aws #yugabytedb #kubernetes #database

13 min read

Franck Pachot for YugabyteDB

Feb 18

Table size in YugabyteDB, PostgreSQL and Oracle 🅾🐘🚀

#yugabytedb #postgres #oracle #size

11 min read

Franck Pachot for YugabyteDB

Feb 17

SQLcl to transfer data from Oracle to PostgreSQL or YugabyteDB 🅾🐘🚀

#postgres #yugabytedb #oracle #csv

3 min read

Franck Pachot for YugabyteDB

Feb 17

YugabyteDB table_id UUID for PostgreSQL tables

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot

Feb 9

Most recent record (of many items) with YugabyteDB 🚀

#postgres #yugabytedb #distributed #sql

11 min read

Franck Pachot for YugabyteDB

Feb 9

YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

#yugabytedb #docker #jdbc #sql

1 min read

DEV Community is a community of 901,019 amazing developers

AWS Heroes

YugabyteDB

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 local read in 🚀 YugabyteDB geo-partitioned tables

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