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 • 13 stars

oracle-statspack-grafana

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

PLpgSQL • 3 stars

Helping YugabyteDB users and application builders

Databases, SQL, Oracle, AWS, YugabyteDB

YugabyteDB

Dev🔁DBA, SQL, NoSQL discussions
Help on YugabyteDB

243 posts published

29 comments written

5 tags followed

Franck Pachot

May 25

Approximate Count for hash sharded YugabyteDB tables

#yugabytedb #postgres #distributed #sql

4 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

May 24

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot for YugabyteDB

May 24

YugabyteDB Community Open Hours: Episode 1, In The Beginning...

#distributed #sql #yugabytedb #postgres

1 min read

Franck Pachot for AWS Heroes

May 23

Generate SQL Script in PostgreSQL

#postgres #tips #sql #database

1 min read

Franck Pachot for AWS Heroes

May 17

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql

10 min read

Franck Pachot for YugabyteDB

May 16

Install extensions from PGDG repo to YugabyteDB in Alma8

2 min read

Franck Pachot for AWS Heroes

May 15

Generate Random Text Strings in PostgreSQL

#postgres #tips #sql #database

1 min read

Franck Pachot for AWS Heroes

May 3

Unwrap Oracle Home .plb

#oracle #troubleshooting #sql #database

1 min read

Franck Pachot for AWS Heroes

May 1

“Multi-AZ” in Amazon RDS and how it may differ from High Availability

#high #availability #sql #database

12 min read

Franck Pachot for YugabyteDB

Apr 30

Importing from Oracle Edition Based Redefinition (EBR) to YugabyteDB

#yugabyted #oracle #migration #postgres

3 min read

Franck Pachot

Apr 28

TiDB: Distributed MySQL with Foreign Key but not Serializable

#distributed #sql #database #tidb

5 min read

Franck Pachot for YugabyteDB

Apr 27

🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

#postgres #yugabytedb #distributed #sql

10 min read

Franck Pachot for YugabyteDB

Apr 26

How ACID is CitusDB?(compared to YugabyteDB)

#distributed #sql #database #yugabytedb

4 min read

Franck Pachot for YugabyteDB

Apr 22

Range indexes for LIKE queries in YugabyteDB

#yugabytedb #postgres #distributed #sql

8 min read

Franck Pachot for YugabyteDB

Apr 20

YugabyteDB: Achieving High Availability and Disaster Recovery with Two Data Centers

#yugabytedb #ha #dr #replication

12 min read

Franck Pachot for AWS Heroes

Apr 19

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

#sql #database #ddl #idempotent

5 min read

Franck Pachot for YugabyteDB

Apr 9

Scalable bounded COUNT DISTINCT in YugabyteDB

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for YugabyteDB

Apr 3

UPSERT in YugabyteDB

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Apr 2

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Mar 19

YugabyteDB column-level locking for UPDATE

#yugabytedb #distributed #sql #lock

2 min read

Franck Pachot for AWS Heroes

Mar 17

AWS EKS: Check if you are on CPU, IO, RAM pressure (a YugabyteDB example)

#linux #cpu #io #memory

7 min read

Franck Pachot for YugabyteDB

Mar 16

Retype a column in YugabyteDB (and PostgreSQL)

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot for YugabyteDB

Mar 14

Scalable sequences in PostgreSQL / YugabyteDB

#yugabytedb #distributed #sql #postgres

3 min read

Franck Pachot for YugabyteDB

Mar 12

Simulate network latency in a YugabyteDB cluster, on a Docker lab

#yugabytedb #docker #network #latency

8 min read

Franck Pachot

Mar 4

YugabyteDB Managed CLI: provisioning a free DB from the command line

#yugabytedb #free #managed #service

3 min read

Franck Pachot for YugabyteDB

Mar 2

Foreign keys referencing partitioned tables in YugabyteDB

#yugabytedb #partitioning #distributed #foreignkey

7 min read

Franck Pachot for YugabyteDB

Feb 8

SELECT DISTINCT pushdown to do a loose index scan (skip scan)

#yugabytedb #postgres #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Feb 7

Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX

#oracle #postgres #yugabytedb #migration

4 min read

Franck Pachot for YugabyteDB

Feb 6

YugabyteDB Recovery Time Objective (RTO) with PgBench: continuous availability with max. 15s latency on infrastructure failure

#yugabytedb #rto #recovery #failover

10 min read

Franck Pachot for YugabyteDB

Feb 3

YugabyteDB Managed API: provisioning a free DB from command line

#yugabytedb #free #managed #service

4 min read

Franck Pachot for AWS Heroes

Feb 2

PostgreSQL: ⚠ when locking though views (TL;DR: test for race conditions and check execution plan with BUFFERS, VERBOSE)

#postgres #sql #lock #view

5 min read

Franck Pachot for YugabyteDB

Jan 31

Testing LSM-Tree merge for Size Amplification in YugabyteDB

#yugabytedb #size #amplification #compaction

6 min read

Franck Pachot for YugabyteDB

Jan 31

LSM-Tree compaction in YugabyteDB - starting a series of posts

#yugabytedb #rocksdb #lsm #sst

3 min read

Franck Pachot for YugabyteDB

Jan 31

SELECT COUNT(*) FROM 🚀WHERE some conditions ;

#yugabytedb #pushdown #offloading #sql

8 min read

Franck Pachot for YugabyteDB

Jan 27

Blogs about by Vlad Mihalcea about YugabyteDB

#yugabytedb #postgres #hibernate #sql

1 min read

Franck Pachot for YugabyteDB

Jan 26

YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

#distributed #sql #transaction #yugabytedb

5 min read

Franck Pachot for AWS Heroes

Jan 25

DynamoDB local in Docker

#dynamodb #transaction #write #local

5 min read

Franck Pachot for YugabyteDB

Jan 22

pREST on YugabyteDB

#postgres #rest #yugabytedb #ords

4 min read

Franck Pachot for AWS Heroes

Jan 19

FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

#mongodb #yugabytedb #postgres #eks

5 min read

Franck Pachot for AWS Heroes

Jan 18

generate_series() in Oracle like in PostgreSQL

#oracle #postgres #sql

2 min read

Franck Pachot for AWS Heroes

Jan 17

YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

#yugabytedb #kubernetes #database #postgres

6 min read

Franck Pachot for AWS Heroes

Jan 12

When are PostgreSQL prepared statements fully prepared for execution?

#postgres #sql #prepared #database

5 min read

Franck Pachot for AWS Heroes

Jan 10

SQL doesn't need the "Single Table Design" but Composite Primary Keys

#sql #dynamodb #composite #keys

13 min read

Franck Pachot for YugabyteDB

Jan 7

🚀Batched Nested Loop to reduce read requests to the distributed storage

#yugabytedb #sql #distributed #database

8 min read

Franck Pachot for AWS Heroes

Jan 7

Scalable Sequence for PostgreSQL

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for YugabyteDB

Jan 6

Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Jan 4

Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

#yugabytedb #postgres #oracle #migration

5 min read

Franck Pachot for YugabyteDB

Jan 3

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

#yugabytedb #postgres #timeseries #sql

4 min read

Franck Pachot for YugabyteDB

Dec 22 '22

Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

#yugabytedb #postgres #extension #compatibility

5 min read

Franck Pachot for YugabyteDB

Dec 21 '22

Adding a PostgreSQL extension to YugabyteDB - example with timestamp9

#yugabytedb #postgres #extension #distributed

6 min read

Franck Pachot for YugabyteDB

Dec 20 '22

A very short demo on updates in YugabyteDB

#yugabytedb #postgres #sql #distributed

3 min read

Franck Pachot for YugabyteDB

Dec 19 '22

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

#oracle #sql #postgres #compatibility

10 min read

Franck Pachot for AWS Heroes

Dec 18 '22

Find active forks of a GitHub repository

#git

2 min read

Franck Pachot

Dec 16 '22

Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

#yugabytedb #postgres #cockroachdb #dump

8 min read

Franck Pachot

Dec 14 '22

A very short demo to show YugabyteDB follower reads

#yugabytedb #ybwr #follower #consistency

2 min read

Franck Pachot for YugabyteDB

Dec 14 '22

INSERT ON CONFLICT returning old values

#postgres #yugabytedb #sql #duplicate

3 min read

Franck Pachot for YugabyteDB

Dec 13 '22

SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

#sql #macro #udf #views

4 min read

Franck Pachot

Dec 12 '22

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

#yugabytedb #postgres #explain #distributed

3 min read

Franck Pachot for YugabyteDB

Dec 8 '22

What is a "truly distributed UDF" ?

#yugabytedb #postgres #udf #sql

4 min read

Franck Pachot for YugabyteDB

Dec 7 '22

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #sql #aggregate

3 min read

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?