Franck Pachot

20 years in databases from dev to prod - Oracle Certified Master, AWS Data Hero, PostgreSQL and YugabyteDB fan, love to learn and share, and scale databases

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

Oct 7

CREATE INDEX in YugabyteDB: online or fast?

#yugabyte #database #index #create

5 min read

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

Oct 4

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

#postgres #yugabyte #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 #yugabyte #database #ha

8 min read

Franck Pachot for Yugabyte

Sep 22

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

#postgres #yugabyte #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

#yugabyte #index #database

7 min read

Franck Pachot for Yugabyte

Aug 30

UUID or cached sequences?

#database #postgres #sql #yugabyte

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

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

Franck Pachot for AWS Heroes

Nov 26 '20

Amazon DynamoDB Local: running NoSQL on SQLite

#aws #dynamodb #local #sqlite

11 min read

Franck Pachot

Nov 25 '20

What is a database backup (back to the basics)

#backup #recovery #postgres #cloud

3 1

15 min read

49:36

Franck Pachot

Nov 25 '20

SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database

#sql #oracle #soda #nosql

1 min read

Franck Pachot for AWS Heroes

Nov 25 '20

DynamoDB PartiQL - part II: SELECT

#aws #dynamodb #partiql #sql

9 min read

Franck Pachot for AWS Heroes

Nov 24 '20

PostgreSQL in AWS: clearing the doubts

#aws #postgres #rds #aurora

15 1

9 min read

Franck Pachot for AWS Heroes

Nov 24 '20

AWS burstable EC2 and CloudWatch metrics

#aws #ec2 #cloudwatch #stolen

6 min read

Franck Pachot for AWS Heroes

Nov 24 '20

DynamoDB PartiQL – part I: INSERT

#aws #dynamodb #sql #insert

7 min read

DEV Community is a community of 717,585 amazing developers

AWS Heroes

Yugabyte

Recent comments

Index Only Scan on Functional Indexes

DynamoDB Scan: the most efficient operation 😉