Franck Pachot

Developer Advocate 🚀 YugabyteDB - postgres compatible 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

Databases, SQL, Oracle, AWS, YugabyteDB

Helping YugabyteDB users and application builders

YugabyteDB

Dev🔁DBA, SQL, NoSQL discussions
Help on YugabyteDB

283 posts published

33 comments written

5 tags followed

Pinned

Franck Pachot for YugabyteDB

Aug 14

Partitioning vs. Sharding - What about SQL Features?

#distributed #sql #sharding #postgres

7 min read

Franck Pachot for YugabyteDB

Sep 21

Bitmap Scan in YugabyteDB

#yugabytedb #distributed #sql #postgres

8 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

Sep 18

YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

#yugabytedb #distributed #sql #postgres

7 min read

Franck Pachot for YugabyteDB

Sep 15

Transaction Internals: Fast Path vs Multi-Shard

#yugabytedb #distribute #sql #postgres

1 min read

Franck Pachot for YugabyteDB

Sep 15

The cost of additional secondary indexes in PostgreSQL & YugabyteDB

#postgres #yugabytedb #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Sep 11

Postgres Join Methods in YugabyteDB

#yugabytedb #postgres #distributed #sql

12 min read

Franck Pachot

Sep 11

ACID properties explained to NoSQL vendors

#sql #nosql #acid #transactional

4 min read

Franck Pachot for YugabyteDB

Sep 4

JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

#yugabytedb #distributed #postgres #json

11 min read

Franck Pachot for YugabyteDB

Aug 30

PL/Python in YugabyteDB

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Aug 25

pg_stat_activity from all servers in YugabyteDB

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot for YugabyteDB

Aug 24

No-gap sequence in PostgreSQL and YugabyteDB

#yugabytedb #postgres #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Aug 15

YugabyteDB is Distributed SQL: resilient and consistent

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Aug 15

Citus is not ACID but Eventually Consistent

#postgres #citus #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Aug 11

YugabyteDB official Dockerfile

#yugabytedb #distributed #sql #docker

2 min read

Franck Pachot for YugabyteDB

Aug 9

Counters with YugabyteDB

#yugabytedb #distributed #sql #postgres

2 min read

Franck Pachot for YugabyteDB

Aug 7

pg-hostname on YugabyteDB compiled and installed directly on the server

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Jul 28

FlameGraphs on Steroids with profiler.firefox.com

#linux #perf #stat #profiler

3 min read

Franck Pachot for YugabyteDB

Jul 27

Another funny benchmark: "hugedbbench"

#yugabytedb #benchmark #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Jul 25

SQL for low code applications: SQLPage

#yugabytedb #postgres #lowcode #sql

2 min read

Franck Pachot for AWS Heroes

Jul 24

PostgreSQL Optimizer Hints Discussion

#postgres #sql #hints #optimizer

5 min read

Franck Pachot for YugabyteDB

Jul 19

Understand what you run before publishing your (silly) benchmark results

#yugabytedb #hammerdb #distributed #postgres

16 min read

Franck Pachot for YugabyteDB

Jul 10

YugabyteDB: set read-only for a single query to allow follower reads

#distributed #postgres #yugabyte #readonly

8 min read

Franck Pachot for AWS Heroes

Jul 5

Query Amazon Redshift from YugabyteDB though PostgreSQL Foreign Data Wrapper and VPC peering

#yugabytedb #postgres #amazon #redshift

7 min read

Franck Pachot for AWS Heroes

Jul 3

Book review: Mastering PostgreSQL 15

#postgres #sql #database #books

5 min read

Franck Pachot for YugabyteDB

Jun 30

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

#yugabytedb #postgres #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Jun 28

Quickly testing an extension from docker image

#yugabytedb #postgres #distributed #sql

2 min read

Franck Pachot for YugabyteDB

Jun 23

wiki.js on YugabyteDB

#yugabytedb #postgres #wiki #opensource

3 min read

Franck Pachot for AWS Heroes

Jun 23

How to Select the First Row of Each Set of Grouped Rows Using GROUP BY

#postgres #tips #yugabytedb #sql

1 min read

Franck Pachot for YugabyteDB

Jun 19

YugabyteDB fast path write

#yugabytedb #distributed #sql #database

9 min read

Franck Pachot for YugabyteDB

Jun 19

Global Unique Constraint on a partitioned table in PostgreSQL and YugabyteDB

#yugabytedb #distributed #postgres #sql

7 min read

Franck Pachot for AWS Heroes

Jun 16

How to Check Your PostgreSQL Version

#postgres #tips #sql #database

1 min read

Franck Pachot for AWS Heroes

Jun 16

Indexing for LIKE Queries in PostgreSQL

#postgres #tips #sql #database

1 min read

Franck Pachot for AWS Heroes

Jun 16

Indexing JSON in PostgreSQL

#postgres #tips #sql #database

1 min read

Franck Pachot for YugabyteDB

Jun 14

One fat index, or two indexes on each columns? PostgreSQL vs. YugabyteDB

#yugabytedb #postgres #distributed #sql

8 min read

Franck Pachot

Jun 13

Approximate COUNT YugabyteDB Community Open Hours: Episode 2: Extensions and Smart Driver

1 min read

Franck Pachot for YugabyteDB

Jun 12

PGLOADBALANCEHOSTS

#postgres #distributed #sql #yugabytedb

4 min read

Franck Pachot for YugabyteDB

Jun 4

UPDATE RETURNING OLD | NEW in YugabyteDB and PostgreSQL

#distributed #postgres #yugabytedb #database

1 min read

Franck Pachot for YugabyteDB

Jun 1

connecting with psql 16 beta to YugabyteDB and use the most recent features

#postgres #yugabytedb #distributed #sql

4 min read

Franck Pachot for YugabyteDB

May 31

Compile pg_math for YugabyteDB (wrapper on GNU Scientific Library distribution functions)

#yugabytedb #distributed #postgres #extension

2 min read

Franck Pachot for AWS Heroes

May 30

DROP TABLE while being read: wait or wound?

#distributed #sql #postgres #yugabytedb

8 min read

Franck Pachot

May 25

Approximate Count for hash sharded YugabyteDB tables

#yugabytedb #postgres #distributed #sql

4 min read

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

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?