DEV Community

Franck Pachot profile picture

Franck Pachot

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

Education

France

Work

Developer Advocate at Yugabyte

YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

1
Comments
2 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 EKS: Check if you are on CPU, IO, RAM pressure (a YugabyteDB example)

AWS EKS: Check if you are on CPU, IO, RAM pressure (a YugabyteDB example)

1
Comments
7 min read
Retype a column in YugabyteDB (and PostgreSQL)

Retype a column in YugabyteDB (and PostgreSQL)

3
Comments
5 min read
Scalable sequences in PostgreSQL / YugabyteDB

Scalable sequences in PostgreSQL / YugabyteDB

Comments
3 min read
Simulate network latency in a YugabyteDB cluster, on a Docker lab

Simulate network latency in a YugabyteDB cluster, on a Docker lab

Comments
8 min read
YugabyteDB Managed CLI: provisioning a free DB from the command line

YugabyteDB Managed CLI: provisioning a free DB from the command line

2
Comments
3 min read
Foreign keys referencing partitioned tables in YugabyteDB

Foreign keys referencing partitioned tables in YugabyteDB

1
Comments
7 min read
SELECT DISTINCT pushdown to do a loose index scan (skip scan)

SELECT DISTINCT pushdown to do a loose index scan (skip scan)

1
Comments
4 min read
Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX

Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX

1
Comments
4 min read
YugabyteDB Recovery Time Objective (RTO) with PgBench: continuous availability with max. 15s latency on infrastructure failure

YugabyteDB Recovery Time Objective (RTO) with PgBench: continuous availability with max. 15s latency on infrastructure failure

2
Comments
10 min read
YugabyteDB Managed API: provisioning a free DB from command line

YugabyteDB Managed API: provisioning a free DB from command line

1
Comments 2
4 min read
PostgreSQL: ⚠ when locking though views (TL;DR: test for race conditions and check execution plan with BUFFERS, VERBOSE)

PostgreSQL: ⚠ when locking though views (TL;DR: test for race conditions and check execution plan with BUFFERS, VERBOSE)

Comments
5 min read
Testing LSM-Tree merge for Size Amplification in YugabyteDB

Testing LSM-Tree merge for Size Amplification in YugabyteDB

Comments
6 min read
LSM-Tree compaction in YugabyteDB - starting a series of posts

LSM-Tree compaction in YugabyteDB - starting a series of posts

Comments
3 min read
SELECT COUNT(*) FROM 🚀WHERE some conditions ;

SELECT COUNT(*) FROM 🚀WHERE some conditions ;

Comments
8 min read
Blogs about by Vlad Mihalcea about YugabyteDB

Blogs about by Vlad Mihalcea about YugabyteDB

Comments
1 min read
YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

Comments
5 min read
DynamoDB local in Docker

DynamoDB local in Docker

5
Comments
5 min read
pREST on YugabyteDB

pREST on YugabyteDB

1
Comments
4 min read
FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

6
Comments
5 min read
generate_series() in Oracle like in PostgreSQL

generate_series() in Oracle like in PostgreSQL

2
Comments
2 min read
YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

2
Comments
6 min read
When are PostgreSQL prepared statements fully prepared for execution?

When are PostgreSQL prepared statements fully prepared for execution?

4
Comments
5 min read
SQL doesn't need the "Single Table Design" but Composite Primary Keys

SQL doesn't need the "Single Table Design" but Composite Primary Keys

13
Comments
13 min read
🚀Batched Nested Loop to reduce read requests to the distributed storage

🚀Batched Nested Loop to reduce read requests to the distributed storage

3
Comments
8 min read
Scalable Sequence for PostgreSQL

Scalable Sequence for PostgreSQL

2
Comments
6 min read
Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

1
Comments
3 min read
Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

Comments
5 min read
Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

3
Comments
4 min read
Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

2
Comments
5 min read
Adding a PostgreSQL extension to YugabyteDB - example with timestamp9

Adding a PostgreSQL extension to YugabyteDB - example with timestamp9

Comments
6 min read
A very short demo on updates in YugabyteDB

A very short demo on updates in YugabyteDB

3
Comments
3 min read
IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

Comments
10 min read
Find active forks of a GitHub repository

Find active forks of a GitHub repository

3
Comments
2 min read
Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

9
Comments
8 min read
A very short demo to show YugabyteDB follower reads

A very short demo to show YugabyteDB follower reads

2
Comments
2 min read
INSERT ON CONFLICT returning old values

INSERT ON CONFLICT returning old values

4
Comments
3 min read
SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

4
Comments
4 min read
EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

3
Comments
3 min read
What is a "truly distributed UDF" ?

What is a "truly distributed UDF" ?

7
Comments
4 min read
Partial Index as an approximate Count(*) Materialized View

Partial Index as an approximate Count(*) Materialized View

2
Comments
3 min read
Index usage monitoring in YugabyteDB & PostgreSQL

Index usage monitoring in YugabyteDB & PostgreSQL

3
Comments
11 min read
Scalable Job Queue in SQL (YugabyteDB)

Scalable Job Queue in SQL (YugabyteDB)

21
Comments 3
5 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

2
Comments
15 min read
Patroni and Availability Zone failure

Patroni and Availability Zone failure

4
Comments
5 min read
DuckDB on YugabyteDB

DuckDB on YugabyteDB

4
Comments
4 min read
Cross-cluster async replication with YugabyteDB xCluster

Cross-cluster async replication with YugabyteDB xCluster

2
Comments
6 min read
YugabyteDB auto-sharding (showing tablet size with Grafana)

YugabyteDB auto-sharding (showing tablet size with Grafana)

4
Comments
8 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

1
Comments
6 min read
How far is my AWS region?

How far is my AWS region?

5
Comments 1
7 min read
MariaDB Xpand Distributed MySQL

MariaDB Xpand Distributed MySQL

2
Comments
8 min read
LSM Tree, Tombstones and YugabyteDB 🚀

LSM Tree, Tombstones and YugabyteDB 🚀

7
Comments
9 min read
YugabyteDB on OKE: testing batch size for bulk load

YugabyteDB on OKE: testing batch size for bulk load

1
Comments
8 min read
Gitpod with YugabyteDB image

Gitpod with YugabyteDB image

Comments
2 min read
Mastodon on YugabyteDB

Mastodon on YugabyteDB

6
Comments
4 min read
🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

Comments
5 min read
YugabyteDB cloud/region/zone

YugabyteDB cloud/region/zone

3
Comments
4 min read
How to set Read Committed in YugabyteDB

How to set Read Committed in YugabyteDB

3
Comments 2
2 min read
Dirty Reads in Oracle Database (is Oracle ACID across failure?)

Dirty Reads in Oracle Database (is Oracle ACID across failure?)

10
Comments 2
5 min read
YugabyteDB Skip Scan aka Loose Index Scan on compound index

YugabyteDB Skip Scan aka Loose Index Scan on compound index

2
Comments
5 min read
loading...