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
Active Session History (ASH) in YugabyteDB

Active Session History (ASH) in YugabyteDB

1
Comments
7 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
Improving Your SQL Indexing: How to Effectively Order Columns

Improving Your SQL Indexing: How to Effectively Order Columns

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

Observing Clock Skew ERROR: 40001 - Restart read required

1
Comments
3 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

4
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

44
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

1
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`

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

Crash on clock skew: performance vs availability

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

3
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

4
Comments 4
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?

5
Comments 4
11 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

10
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

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

6
Comments
21 min read
Out of Range statistics with PostgreSQL & YugabyteDB

Out of Range statistics with PostgreSQL & YugabyteDB

Comments 1
7 min read
Best Practice: use the same datatypes for comparisons, like joins and foreign keys

Best Practice: use the same datatypes for comparisons, like joins and foreign keys

Comments
7 min read
YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

Comments
4 min read
Data Residency Compliance: PostgreSQL RLS to access YugabyteDB local region

Data Residency Compliance: PostgreSQL RLS to access YugabyteDB local region

1
Comments
8 min read
UUID in PostgreSQL

UUID in PostgreSQL

45
Comments 7
5 min read
YugabyteDB avoids bloat with the outbox pattern

YugabyteDB avoids bloat with the outbox pattern

3
Comments
6 min read
Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

2
Comments
12 min read
Repeatable Read with Wait-On-Conflict, and Restarts

Repeatable Read with Wait-On-Conflict, and Restarts

2
Comments
7 min read
Batched Nested Loop and Unbatchable Conditions

Batched Nested Loop and Unbatchable Conditions

2
Comments
5 min read
UPSERT all columns in YugabyteDB (ON CONFLICT DO UPDATE)

UPSERT all columns in YugabyteDB (ON CONFLICT DO UPDATE)

1
Comments
4 min read
Isolation Levels - part XIII: Explicit Locking with SELECT (FOR UPDATE) intention

Isolation Levels - part XIII: Explicit Locking with SELECT (FOR UPDATE) intention

3
Comments
12 min read
pg_hint_plan for Batched Nested Loop Join in YugabyteDB

pg_hint_plan for Batched Nested Loop Join in YugabyteDB

Comments
5 min read
Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Comments
24 min read
`OR` Filter on Two Tables, and Batched Nested Loops

`OR` Filter on Two Tables, and Batched Nested Loops

1
Comments
6 min read
Single-statement deadlock in Oracle and ORA-00060

Single-statement deadlock in Oracle and ORA-00060

Comments
4 min read
Isolation Levels - part XII: To go further

Isolation Levels - part XII: To go further

Comments 2
2 min read
Distributed PostgreSQL without sharding constraint for SQL joins

Distributed PostgreSQL without sharding constraint for SQL joins

Comments
4 min read
Isolation Levels - part XI: Read Uncommitted

Isolation Levels - part XI: Read Uncommitted

Comments 2
1 min read
Isolation Levels - part X: Non-Transactional Writes

Isolation Levels - part X: Non-Transactional Writes

1
Comments
2 min read
ON CONFLICT DO NOTHING in YugabyteDB

ON CONFLICT DO NOTHING in YugabyteDB

Comments
4 min read
Even a Better Index 🍃 for The Most Annoying Postgres Optimizer Fail

Even a Better Index 🍃 for The Most Annoying Postgres Optimizer Fail

Comments
6 min read
Isolation Levels - part IX: Read Committed

Isolation Levels - part IX: Read Committed

1
Comments 8
4 min read
Extended Statistics and pg_hint_plan /*+ Rows() */

Extended Statistics and pg_hint_plan /*+ Rows() */

2
Comments 2
7 min read
Pagination with an OFFSET is better without OFFSET

Pagination with an OFFSET is better without OFFSET

2
Comments
5 min read
The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

10
Comments 1
9 min read
Isolation Levels - part VIII: Cursor Stability

Isolation Levels - part VIII: Cursor Stability

Comments
1 min read
Quick 📸 on 🐘 wait events from pg_stat_activity

Quick 📸 on 🐘 wait events from pg_stat_activity

4
Comments
2 min read
Batched Nested Loop for Join With Large Pagination

Batched Nested Loop for Join With Large Pagination

3
Comments
6 min read
Docker container with fixed IP address

Docker container with fixed IP address

Comments
2 min read
How to Optimize Indexing for Distributed One-to-Many Join With Pagination

How to Optimize Indexing for Distributed One-to-Many Join With Pagination

11
Comments
6 min read
Isolation Levels - part VII: Repeatable Read

Isolation Levels - part VII: Repeatable Read

1
Comments
3 min read
Isolation Levels - part VI: Snapshot Isolation

Isolation Levels - part VI: Snapshot Isolation

Comments
2 min read
Isolation Levels - part V: Read Only

Isolation Levels - part V: Read Only

4
Comments 1
3 min read
Amazon Aurora PostgreSQL shared buffers and cache

Amazon Aurora PostgreSQL shared buffers and cache

4
Comments
6 min read
loading...