Franck Pachot

Love to learn and share, with 20 years in databases from dev to prod - Oracle Certified Master, AWS Data Hero, PostgreSQL fan and now 🚀 YugabyteDB open-source distributed SQL database.

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

Work

Developer Advocate at Yugabyte

Pinned

Franck Pachot for Yugabyte

Mar 21

Foreign Keys in MySQL, NoSQL, NewSQL (YugaByteDB)

#foreignkey #sql #yugabytedb #postgres

11 min read

Franck Pachot for Yugabyte

Dec 6

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

#yugabytedb #distributed #sql #database

6 min read

Linux buffered write latency

Adding to this, to help google searches, that Available Memor...

Nov 24

Stored Procedures - love or leave 'em?

On the "love or leave 'em?" question, I easily apply a three-...

Oct 22

Index Only Scan on Functional Indexes

Right, include is the one I wanted to put there and I'll upda...

Aug 24

DynamoDB Scan: the most efficient operation 😉

Good point. With Single Table Design, it probably makes no se...

Mar 10

Franck Pachot for Yugabyte

Dec 1

🌎🌍🌏 Yugabyte cross-continent deployment 🚀

#yugabytedb #distributed #sql #database

11 min read

Franck Pachot for Yugabyte

Nov 30

Yugabyte COPY batch size

#yugabytedb #distributed #sql #database

4 min read

Franck Pachot for Yugabyte

Nov 29

Text Search example with the OMDB sample database

#yugabytedb #distributed #sql #postgres

7 min read

Franck Pachot for AWS Heroes

Nov 22

Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

#yugabytedb #redshift #sql #database

5 min read

Franck Pachot for Yugabyte

Nov 21

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

#yugabytedb #distributed #sql #webdev

8 min read

Franck Pachot

Nov 19

kokizzu/hugedbbench

#yugabytedb #sql #database

12 min read

Franck Pachot for Yugabyte

Nov 15

ORDER BY is mandatory in SQL to get a sorted result

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for Yugabyte

Nov 7

🚀 Think about Primary Key & Indexes before anything else 🐘

#yugabytedb #database #postgres #sql

8 min read

Franck Pachot for Yugabyte

Nov 3

Open-source🍃MongoDB API to 🚀YugabyteDB with 🥭MangoDB proxy

#postgres #yugabytedb #mongodb #proxy

7 min read

Franck Pachot for Yugabyte

Oct 28

COPY progression in YugabyteDB

#yugabytedb #postgres #copy #database

5 min read

Franck Pachot for Yugabyte

Oct 20

Boost Secondary Index Queries with Index Only Scan

#postgres #yugabytedb #index #sql

11 min read

Franck Pachot for Yugabyte

Oct 7

CREATE INDEX in YugabyteDB: online or fast?

#yugabytedb #database #index #create

6 min read

Franck Pachot for Yugabyte

Oct 4

hyper-scale multi-tenant for SaaS: an example with pgbench

#postgres #yugabytedb #pgbench #saas

12 min read

Franck Pachot for Yugabyte

Sep 28

Bulk load into PostgreSQL / YugabyteDB - psycopg2

#postgres #python #database #copy

4 min read

Franck Pachot for Yugabyte

Sep 28

The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

#postgres #yugabytedb #database #ha

8 min read

Franck Pachot for Yugabyte

Sep 22

when you have millions of insert statements in a file...

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for Yugabyte

Sep 19

YugabyteDB on OKE

#yugabytedb #oraclecloud #kubernetes #database

11 min read

Franck Pachot for AWS Heroes

Sep 6

Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

#aws #aurora #postgres #database

8 min read

Franck Pachot for Yugabyte

Sep 3

Index Scan in YugabyteDB

#yugabytedb #index #database

7 min read

Franck Pachot for Yugabyte

Aug 30

UUID or cached sequences?

#database #postgres #sql #yugabytedb

7 min read

Franck Pachot for AWS Heroes

Aug 24

Pressure Stall Information on CentOS7

#linux #performance #psi

3 min read

Franck Pachot for AWS Heroes

Aug 24

Index Only Scan on Functional Indexes

#postgres #sql #database

20 2

4 min read

Franck Pachot for AWS Heroes

Aug 22

A kind of flashback query in PostgreSQL

#postgres #database #sql

3 min read

Franck Pachot for Yugabyte

Aug 19

pgbench --client --jobs

#postgres #pgbench

8 min read

Franck Pachot for Yugabyte

Aug 17

usql on YugabyteDB

#yugabytedb #sql #database

4 min read

Franck Pachot for Yugabyte

Aug 5

Visible number of cpu on OpenVZ and LXC

#containers #kubernetes #openvz #cpu

5 min read

Franck Pachot for Yugabyte

Aug 2

VisiData to read JSON, HTML and YugabyteDB

#visidata #yugabytedb

4 1

5 min read

Franck Pachot for AWS Heroes

Jul 28

PostgreSQL prepared statements in PL/pgSQL

#postgres #plpgsql #prepared #oltp

4 min read

Franck Pachot for Yugabyte

Jul 28

Arctype connects to YugabyteDB

#sql #yugabytedb

6 min read

Franck Pachot for Yugabyte

Jul 27

SLOB on YugabyteDB

#yugabytedb #benchmark #slob

6 min read

Franck Pachot for Yugabyte

Jul 21

YugabyteDB on OCI Free Tier

#yugabytedb

3 min read

Franck Pachot for Yugabyte

Jul 19

jOOQ on YugabyteDB

#java #yugabytedb #jooq #sql

5 min read

Franck Pachot for Yugabyte

Jul 14

HASH or RANGE in distributed databases

#sql #sharding #yugabytedb #database

11 min read

Franck Pachot for AWS Heroes

Jul 13

READ COMMITTED anomalies in PostgreSQL

#database #sql #postgres

5 min read

Franck Pachot for Yugabyte

Jul 8

EXPLAIN ANALYZE on COUNT() pushdown

#yugabytedb #postgres #explain #database

7 min read

Franck Pachot for Yugabyte

Jul 5

pg_hint_plan and single-table cardinality correction

#postgres #yugabytedb #sql #database

8 min read

Franck Pachot for AWS Heroes

May 29

Amazon RDS Oracle in Multitenant

#rds #oracle #cdb #multitenant

6 min read

Franck Pachot for AWS Heroes

May 19

PostgreSQL on AWS Graviton2: CFLAGS

#postgres #database #aarch64 #aws

8 min read

Franck Pachot for AWS Heroes

May 15

AWS Aurora vs. RDS PostgreSQL on frequent commits

#aws #postgres #aurora #database

7 min read

Franck Pachot for AWS Heroes

May 15

AWS Aurora IO:XactSync is not a PostgreSQL wait event

#aws #postgres #aurora #database

10 min read

Franck Pachot for AWS Heroes

May 15

Oracle Standard Edition on AWS ☁ socket arithmetic

#oracle #standardedition #aws #license

6 min read

Franck Pachot for AWS Heroes

May 15

AWS: PostgreSQL on Graviton2 with newer GCC

#aws #postgres #graviton2 #gcc

18 min read

Franck Pachot

May 15

An example of ORA-01152: file ... was not restored from a sufficiently old backup

#oracle #recovery #rman #resetlogs

20 min read

Franck Pachot for AWS Heroes

May 15

DynamoDB / Aurora: sparse and partial indexes

#dynamodb #aurora #index #nosql

7 min read

Franck Pachot for AWS Heroes

May 15

Amazon DynamoDB: a r(el)ational Glossary

#dynamodb #relational #table #item

9 min read

Franck Pachot

May 15

El Carro: The Oracle Operator for Kubernetes

#google #oracle #operator #kubernetes

7 min read

Franck Pachot for Yugabyte

Apr 12

K8s on Windows/VirtualBox (and a DB)

#kubernetes #windows #sql #yugabytedb

9 min read

Franck Pachot

Mar 21

Linux perf-top basics: understand the %

#linux #perf #overhead

9 min read

Franck Pachot for AWS Heroes

Mar 8

Amazon Aurora: calling a lambda from a trigger

#aws #lambda #trigger

10 min read

Franck Pachot for AWS Heroes

Mar 8

DynamoDB Scan: the most efficient operation 😉

#aws #dynamodb #scan

30 3

7 min read

Franck Pachot

Mar 8

Pressure Stall Information on Autonomous Linux

#linux #psi #pressure

9 min read

Franck Pachot

Mar 8

PostgreSQL on Linux: what is cached?

#postgres #linux #cache

9 min read

Franck Pachot

Mar 8

Grafana, SQL and IN() list for multi-value variable

#grafana #sql #list

5 min read

Franck Pachot for AWS Heroes

Mar 8

AWS: PostgreSQL on Graviton2

#aws #postgres #graviton2 #arm

5 min read

Franck Pachot

Dec 11 '20

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

#google #postgres #backup

22 min read

Franck Pachot for AWS Heroes

Dec 8 '20

Aurora Serverless v2 (preview) - CPU

#amazon #aurora #serverless #cpu

8 min read

Franck Pachot for AWS Heroes

Dec 8 '20

Aurora Serverless v2 (preview) - RAM

#amazon #aurora #serverless #ram

12 min read

Franck Pachot for AWS Heroes

Nov 30 '20

DynamoDB Scan (and why 128.5 RCU?)

#aws #dynamodb #scan #pagination

13 min read

Franck Pachot for AWS Heroes

Nov 29 '20

PMM Server on AWS: which TCP ports to open

#aws #pmm #monitoring

8 min read

DEV Community is a community of 757,079 amazing developers

AWS Heroes

Yugabyte

Recent comments

Linux buffered write latency

Stored Procedures - love or leave 'em?

Index Only Scan on Functional Indexes

DynamoDB Scan: the most efficient operation 😉