DEV Community

Franck Pachot profile picture

Franck Pachot

Developer Advocate ▝▞ YugabyteDB - postgres compatible distributed SQL open-source database, 🔶AWS Data Hero, 🅾Oracle ACE Alumni & OCM, 🐘 PostgreSQL fan

Education

France

Work

Developer Advocate at Yugabyte

Writing Debut
2 Week Community Wellness Streak
Five Year Club
Four Year Club
1 Week Community Wellness Streak
16 Week Writing Streak
Three Year Club
8 Week Writing Streak
4 Week Writing Streak
Two Year Club
One Year Club
YugabyteDB as a Graph database with PuppyGraph

YugabyteDB as a Graph database with PuppyGraph

Comments
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.

Already have an account? Sign in
AWS re:Invent 2024 - Which sessions I'll try to attend.

AWS re:Invent 2024 - Which sessions I'll try to attend.

6
Comments
7 min read
PostgreSQL Semi Join, Unique-ify RHS, Materialized CTEs, and Rows Estimation

PostgreSQL Semi Join, Unique-ify RHS, Materialized CTEs, and Rows Estimation

1
Comments
9 min read
Native GLIBC instead of Linuxbrew since 2.21

Native GLIBC instead of Linuxbrew since 2.21

Comments
3 min read
pgSphere and Q3C on Distributed SQL

pgSphere and Q3C on Distributed SQL

Comments
4 min read
IN() Index Scan in PostgreSQL 17 and YugabyteDB LSM Tree

IN() Index Scan in PostgreSQL 17 and YugabyteDB LSM Tree

1
Comments
9 min read
Frequent Re-Connections improved by Connection Manager

Frequent Re-Connections improved by Connection Manager

Comments
4 min read
Maintaining Throughput With Less Physical Connections

Maintaining Throughput With Less Physical Connections

Comments
6 min read
YugabyteDB Connection Manager: a Database Resident Connection Pool with Shared Processes

YugabyteDB Connection Manager: a Database Resident Connection Pool with Shared Processes

Comments
7 min read
ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index

ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index

6
Comments
4 min read
Write Buffering to Reduce Raft Consensus Latency in YugabyteDB

Write Buffering to Reduce Raft Consensus Latency in YugabyteDB

5
Comments
11 min read
Asynch replication for Disaster Recovery, Read Replicas, and Change Data Capture

Asynch replication for Disaster Recovery, Read Replicas, and Change Data Capture

Comments
3 min read
Fast PITR and MVCC reads with Key-Value LSM Tree

Fast PITR and MVCC reads with Key-Value LSM Tree

Comments
4 min read
RocksDB, Key-Value Storage, and Packed Rows: the backbone of YugabyteDB's distributed tablets flexibility

RocksDB, Key-Value Storage, and Packed Rows: the backbone of YugabyteDB's distributed tablets flexibility

1
Comments
3 min read
SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes

SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes

2
Comments
4 min read
Batching and Push-Downs to Distribute with High-Performance reads and writes

Batching and Push-Downs to Distribute with High-Performance reads and writes

1
Comments
7 min read
Fault Tolerance with Raft and no Single Point of Failure

Fault Tolerance with Raft and no Single Point of Failure

Comments
3 min read
Linearly Scalable Architecture with Separation of Concern

Linearly Scalable Architecture with Separation of Concern

Comments
2 min read
Most Complete Auto-Sharding and Partitioning Strategies

Most Complete Auto-Sharding and Partitioning Strategies

Comments
1 min read
Pessimistic locking, Read Committed, and all Isolation Levels

Pessimistic locking, Read Committed, and all Isolation Levels

1
Comments
2 min read
Unique PostgreSQL-compatible Distributed SQL database

Unique PostgreSQL-compatible Distributed SQL database

Comments
4 min read
🧵10 Facts About YugabyteDB: Misconceptions Debunked

🧵10 Facts About YugabyteDB: Misconceptions Debunked

1
Comments
1 min read
Physically isolating tenants with tablespaces and smart drivers in YugabyteDB

Physically isolating tenants with tablespaces and smart drivers in YugabyteDB

1
Comments
5 min read
Implementing “Get or Create” in YugabyteDB (or PostgreSQL)

Implementing “Get or Create” in YugabyteDB (or PostgreSQL)

2
Comments
11 min read
Multi-Statement SQL for reducing write latency in YugabyteDB (and PostgreSQL alternative to INSERT ALL)

Multi-Statement SQL for reducing write latency in YugabyteDB (and PostgreSQL alternative to INSERT ALL)

1
Comments
7 min read
Different Roles for Read Replicas in PostgreSQL and YugabyteDB

Different Roles for Read Replicas in PostgreSQL and YugabyteDB

4
Comments
7 min read
Clustering Factor for YugabyteDB Index Scan: correlation between secondary indexes and the primary key

Clustering Factor for YugabyteDB Index Scan: correlation between secondary indexes and the primary key

Comments
8 min read
Performance of range queries in B-Tree and LSM indexes

Performance of range queries in B-Tree and LSM indexes

20
Comments
9 min read
Observing CPU/RAM/IO pressure in YugabyteDB with Linux PSI on AlmaLinux8 (Pressure Stall Information)

Observing CPU/RAM/IO pressure in YugabyteDB with Linux PSI on AlmaLinux8 (Pressure Stall Information)

1
Comments
8 min read
Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL

Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL

10
Comments 3
3 min read
Distributing PostgreSQL on Amazon Elastic Kubernetes

Distributing PostgreSQL on Amazon Elastic Kubernetes

3
Comments
7 min read
Find hotspots with Yugabyte Active Session History

Find hotspots with Yugabyte Active Session History

2
Comments
2 min read
Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

4
Comments
4 min read
Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB

Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB

8
Comments
4 min read
Active Session History (ASH) in YugabyteDB

Active Session History (ASH) in YugabyteDB

1
Comments
7 min read
Improving Your SQL Indexing: How to Effectively Order Columns

Improving Your SQL Indexing: How to Effectively Order Columns

2
Comments
1 min read
Observing Clock Skew ERROR: 40001 - Restart read required

Observing Clock Skew ERROR: 40001 - Restart read required

2
Comments
5 min read
Multi-Region Async Table Broadcast with YugabyteDB xCluster 1-to-N replication

Multi-Region Async Table Broadcast with YugabyteDB xCluster 1-to-N replication

2
Comments
8 min read
Deletes and MVCC in YugabyteDB

Deletes and MVCC in YugabyteDB

3
Comments
12 min read
Partitions, Merge Append, Pagination, and Limit pushdown in YugabyteDB

Partitions, Merge Append, Pagination, and Limit pushdown in YugabyteDB

Comments
6 min read
The Log Is (not) The Database

The Log Is (not) The Database

45
Comments
9 min read
Distributed PostgreSQL with YugabyteDB Multi-Region Kubernetes / Istio / Amazon EKS

Distributed PostgreSQL with YugabyteDB Multi-Region Kubernetes / Istio / Amazon EKS

3
Comments
2 min read
YB-Master, the YugabyteDB Universe control plane

YB-Master, the YugabyteDB Universe control plane

1
Comments
5 min read
Multi-AZ PostgreSQL COMMIT wait events: WALSync, SyncRep & XactSync

Multi-AZ PostgreSQL COMMIT wait events: WALSync, SyncRep & XactSync

2
Comments
5 min read
Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

1
Comments
4 min read
Crash on clock skew: performance vs availability

Crash on clock skew: performance vs availability

2
Comments
7 min read
Advisory/Custom/Application Lock with YugabyteDB

Advisory/Custom/Application Lock with YugabyteDB

Comments
5 min read
A lightweight YugabyteDB docker image for CI/CD

A lightweight YugabyteDB docker image for CI/CD

Comments
2 min read
A smaller YugabyteDB image for CI/CD (example with Sakila)

A smaller YugabyteDB image for CI/CD (example with Sakila)

2
Comments
3 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

8
Comments
6 min read
Snapshot too old in YugabyteDB

Snapshot too old in YugabyteDB

Comments
5 min read
Simulate Clock Skew in Docker Container

Simulate Clock Skew in Docker Container

1
Comments
2 min read
MongoDB Associate Data Modeler Exam

MongoDB Associate Data Modeler Exam

7
Comments 5
4 min read
"ERROR: Perform RPC timed out after 602.000s" in YSQL

"ERROR: Perform RPC timed out after 602.000s" in YSQL

Comments
2 min read
PostgreSQL with modern storage: what about a lower random_page_cost?

PostgreSQL with modern storage: what about a lower random_page_cost?

6
Comments 4
11 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

11
Comments 7
17 min read
B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

Comments 9
10 min read
YugabyteDB Transactional Load with Non-transactional COPY

YugabyteDB Transactional Load with Non-transactional COPY

1
Comments 1
3 min read
What's the equivalent of pageinspect in YugabyteDB?

What's the equivalent of pageinspect in YugabyteDB?

Comments
15 min read
Postgres dead tuple space reused without vacuum

Postgres dead tuple space reused without vacuum

11
Comments
21 min read
loading...