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

Partial Index as an approximate Count(*) Materialized View

Partial Index as an approximate Count(*) Materialized View

Reactions 1 Comments
3 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
Index usage monitoring in YugabyteDB & PostgreSQL

Index usage monitoring in YugabyteDB & PostgreSQL

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

Scalable Job Queue in SQL (YugabyteDB)

Reactions 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

Reactions 2 Comments
15 min read
Patroni and Availability Zone failure

Patroni and Availability Zone failure

Reactions 4 Comments
5 min read
DuckDB on YugabyteDB

DuckDB on YugabyteDB

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

Cross-cluster async replication with YugabyteDB xCluster

Reactions 2 Comments
5 min read
YugabyteDB auto-sharding

YugabyteDB auto-sharding

Reactions 4 Comments
8 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

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

How far is my AWS region?

Reactions 4 Comments 1
7 min read
MariaDB Xpand Distributed MySQL

MariaDB Xpand Distributed MySQL

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

LSM Tree, Tombstones and YugabyteDB 🚀

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

YugabyteDB on OKE: testing batch size for bulk load

Reactions 1 Comments
8 min read
Gitpod with YugabyteDB image

Gitpod with YugabyteDB image

Comments
2 min read
Mastodon on YugabyteDB

Mastodon on YugabyteDB

Reactions 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

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

How to set Read Committed in YugabyteDB

Reactions 2 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?)

Reactions 8 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

Reactions 2 Comments
5 min read
Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Reactions 3 Comments
6 min read
SingleStore - is there a workaround for unsupported Foreign Key?

SingleStore - is there a workaround for unsupported Foreign Key?

Reactions 2 Comments
6 min read
pg_hint_plan: Get the right plan without surprises

pg_hint_plan: Get the right plan without surprises

Reactions 1 Comments
1 min read
Real Application Testing on 🚀YugabyteDB 🐘pgreplay

Real Application Testing on 🚀YugabyteDB 🐘pgreplay

Reactions 3 Comments
4 min read
Moving rows from one table to the other 🐘 🚀

Moving rows from one table to the other 🐘 🚀

Comments
2 min read
Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain

Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain

Reactions 1 Comments
5 min read
Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

Reactions 1 Comments
7 min read
Declarative vs. Application side Foreign Key referential integrity

Declarative vs. Application side Foreign Key referential integrity

Reactions 3 Comments
10 min read
pg_stat_statements with pg_hint_plan

pg_stat_statements with pg_hint_plan

Reactions 5 Comments
3 min read
EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

Reactions 4 Comments
6 min read
Nakama with YugabyteDB

Nakama with YugabyteDB

Reactions 3 Comments
2 min read
SingleStore compared to YugabyteDB

SingleStore compared to YugabyteDB

Reactions 5 Comments
6 min read
Read local partition first, then global if not found locally

Read local partition first, then global if not found locally

Reactions 5 Comments
7 min read
Fixing Docker image vulnerabilities (with centos2ol.sh)

Fixing Docker image vulnerabilities (with centos2ol.sh)

Reactions 3 Comments
4 min read
YugabyteDB in a Micro VM with no network

YugabyteDB in a Micro VM with no network

Comments
3 min read
pg_hint_plan with subqueries

pg_hint_plan with subqueries

Reactions 2 Comments
4 min read
Parallelizing aggregates in YugabyteDB

Parallelizing aggregates in YugabyteDB

Reactions 2 Comments
4 min read
Fastest start of YugabyteDB for a small lab

Fastest start of YugabyteDB for a small lab

Reactions 1 Comments
2 min read
Bookmarklet for YugabyteDB table's tablets

Bookmarklet for YugabyteDB table's tablets

Reactions 4 Comments
2 min read
Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Reactions 3 Comments
4 min read
Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

Reactions 7 Comments
5 min read
🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

Reactions 12 Comments
3 min read
Default tablet splitting in YugabyteDB 🚀

Default tablet splitting in YugabyteDB 🚀

Reactions 7 Comments
5 min read
📜 select * from 🚀 logfile with 🐘 file_fdw

📜 select * from 🚀 logfile with 🐘 file_fdw

Reactions 1 Comments
2 min read
YugabyteDB cardinality estimation in the absence of ANALYZE statistics

YugabyteDB cardinality estimation in the absence of ANALYZE statistics

Reactions 5 Comments
9 min read
IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

Reactions 9 Comments
4 min read
⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

Reactions 6 Comments 3
6 min read
🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

Reactions 6 Comments
5 min read
access the local partition only in 🚀 YugabyteDB geo-partitioned tables

access the local partition only in 🚀 YugabyteDB geo-partitioned tables

Reactions 12 Comments
4 min read
find the partition key with a duplicate covering index local read

find the partition key with a duplicate covering index local read

Reactions 9 Comments 2
8 min read
JPA and PostgreSQL text

JPA and PostgreSQL text

Reactions 9 Comments 3
3 min read
The YugabyteDB configuration parameters (GFLAGs and GUCs)

The YugabyteDB configuration parameters (GFLAGs and GUCs)

Reactions 5 Comments
5 min read
Optimizing Nested Loop joins on YugabyteDB with jOOQ

Optimizing Nested Loop joins on YugabyteDB with jOOQ

Reactions 8 Comments
4 min read
geo-distribution with 🚀 YugabyteDB tablespaces

geo-distribution with 🚀 YugabyteDB tablespaces

Reactions 9 Comments
4 min read
Local reads from 🚀YugabyteDB Read Replicas

Local reads from 🚀YugabyteDB Read Replicas

Reactions 7 Comments
7 min read
Local reads from 🚀YugabyteDB raft followers

Local reads from 🚀YugabyteDB raft followers

Reactions 10 Comments 1
6 min read
🚀 hash+hash partitioning+sharding

🚀 hash+hash partitioning+sharding

Reactions 10 Comments
6 min read
(beta) yugabyted GUI

(beta) yugabyted GUI

Reactions 9 Comments
2 min read
PITR snapshot: an easy flashback / backtrack for application releases

PITR snapshot: an easy flashback / backtrack for application releases

Reactions 8 Comments
7 min read
Nested Loop performance in YugabyteDB

Nested Loop performance in YugabyteDB

Reactions 10 Comments
12 min read
loading...