DEV Community

Franck Pachot profile picture

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

Work

Developer Advocate at Yugabyte

CREATE INDEX in YugabyteDB: online or fast?

CREATE INDEX in YugabyteDB: online or fast?

Reactions 3 Comments
5 min read
hyper-scale multi-tenant for SaaS: an example with pgbench

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

Reactions 5 Comments
12 min read
Bulk load into PostgreSQL / YugabyteDB - psycopg2

Bulk load into PostgreSQL / YugabyteDB - psycopg2

Reactions 5 Comments
4 min read
The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

Reactions 5 Comments
8 min read
when you have millions of insert statements in a file...

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

Reactions 26 Comments
6 min read
YugabyteDB on OKE

YugabyteDB on OKE

Reactions 1 Comments
11 min read
Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

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

Reactions 10 Comments
8 min read
Index Scan in YugabyteDB

Index Scan in YugabyteDB

Reactions 3 Comments
7 min read
UUID or cached sequences?

UUID or cached sequences?

Reactions 9 Comments
7 min read
Pressure Stall Information on CentOS7

Pressure Stall Information on CentOS7

Reactions 6 Comments
3 min read
Index Only Scan on Functional Indexes

Index Only Scan on Functional Indexes

Reactions 20 Comments 2
4 min read
A kind of flashback query in PostgreSQL

A kind of flashback query in PostgreSQL

Reactions 9 Comments
3 min read
pgbench --client --jobs

pgbench --client --jobs

Reactions 3 Comments
8 min read
usql on YugabyteDB

usql on YugabyteDB

Reactions 2 Comments
4 min read
Visible number of cpu on OpenVZ and LXC

Visible number of cpu on OpenVZ and LXC

Reactions 5 Comments
5 min read
VisiData to read JSON, HTML and YugabyteDB

VisiData to read JSON, HTML and YugabyteDB

Reactions 2 Comments
5 min read
PostgreSQL prepared statements in PL/pgSQL

PostgreSQL prepared statements in PL/pgSQL

Reactions 7 Comments
4 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

Reactions 2 Comments
6 min read
SLOB on YugabyteDB

SLOB on YugabyteDB

Reactions 2 Comments
6 min read
YugabyteDB on OCI Free Tier

YugabyteDB on OCI Free Tier

Reactions 5 Comments
3 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

Reactions 2 Comments
5 min read
HASH or RANGE in distributed databases

HASH or RANGE in distributed databases

Reactions 1 Comments
11 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

Reactions 7 Comments
5 min read
EXPLAIN ANALYZE on COUNT() pushdown

EXPLAIN ANALYZE on COUNT() pushdown

Reactions 4 Comments
7 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

Reactions 7 Comments
8 min read
Amazon RDS Oracle in Multitenant

Amazon RDS Oracle in Multitenant

Reactions 1 Comments
6 min read
PostgreSQL on AWS Graviton2: CFLAGS

PostgreSQL on AWS Graviton2: CFLAGS

Reactions 1 Comments
8 min read
AWS Aurora vs. RDS PostgreSQL on frequent commits

AWS Aurora vs. RDS PostgreSQL on frequent commits

Reactions 9 Comments
7 min read
AWS Aurora IO:XactSync is not a PostgreSQL wait event

AWS Aurora IO:XactSync is not a PostgreSQL wait event

Reactions 3 Comments
10 min read
Oracle Standard Edition on AWS ☁ socket arithmetic

Oracle Standard Edition on AWS ☁ socket arithmetic

Reactions 2 Comments
6 min read
AWS: PostgreSQL on Graviton2 with newer GCC

AWS: PostgreSQL on Graviton2 with newer GCC

Reactions 3 Comments
18 min read
An example of ORA-01152: file ... was not restored from a sufficiently old backup

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

Reactions 1 Comments
20 min read
DynamoDB / Aurora: sparse and partial indexes

DynamoDB / Aurora: sparse and partial indexes

Reactions 5 Comments
7 min read
Amazon DynamoDB: a r(el)ational Glossary

Amazon DynamoDB: a r(el)ational Glossary

Reactions 2 Comments
9 min read
El Carro: The Oracle Operator for Kubernetes

El Carro: The Oracle Operator for Kubernetes

Reactions 1 Comments
7 min read
K8s on Windows/VirtualBox (and a DB)

K8s on Windows/VirtualBox (and a DB)

Reactions 6 Comments
9 min read
Linux perf-top basics: understand the %

Linux perf-top basics: understand the %

Reactions 6 Comments
9 min read
Amazon Aurora: calling a lambda from a trigger

Amazon Aurora: calling a lambda from a trigger

Comments
10 min read
DynamoDB Scan: the most efficient operation πŸ˜‰

DynamoDB Scan: the most efficient operation πŸ˜‰

Reactions 30 Comments 3
7 min read
Pressure Stall Information on Autonomous Linux

Pressure Stall Information on Autonomous Linux

Comments
9 min read
PostgreSQL on Linux: what is cached?

PostgreSQL on Linux: what is cached?

Reactions 1 Comments
9 min read
Grafana, SQL and IN() list for multi-value variable

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

Reactions 1 Comments
5 min read
AWS: PostgreSQL on Graviton2

AWS: PostgreSQL on Graviton2

Reactions 8 Comments
5 min read
Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

Reactions 2 Comments
22 min read
Aurora Serverless v2 (preview) - CPU

Aurora Serverless v2 (preview) - CPU

Reactions 2 Comments
8 min read
Aurora Serverless v2 (preview) - RAM

Aurora Serverless v2 (preview) - RAM

Reactions 6 Comments
12 min read
DynamoDB Scan (and why 128.5 RCU?)

DynamoDB Scan (and why 128.5 RCU?)

Reactions 7 Comments
13 min read
PMM Server on AWS: which TCP ports to open

PMM Server on AWS: which TCP ports to open

Reactions 4 Comments
8 min read
Amazon DynamoDB Local: running NoSQL on SQLite

Amazon DynamoDB Local: running NoSQL on SQLite

Reactions 4 Comments
11 min read
What is a database backup (back to the basics)

What is a database backup (back to the basics)

Reactions 3 Comments 1
15 min read
SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database 49:36

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

Reactions 2 Comments
1 min read
DynamoDB PartiQL - part II: SELECT

DynamoDB PartiQL - part II: SELECT

Reactions 8 Comments
9 min read
PostgreSQL in AWS: clearing the doubts

PostgreSQL in AWS: clearing the doubts

Reactions 15 Comments 1
9 min read
AWS burstable EC2 and CloudWatch metrics

AWS burstable EC2 and CloudWatch metrics

Reactions 5 Comments
6 min read
DynamoDB PartiQL – part I: INSERT

DynamoDB PartiQL – part I: INSERT

Reactions 12 Comments
7 min read
loading...