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

Approximate Count for hash sharded YugabyteDB tables

Approximate Count for hash sharded YugabyteDB tables

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
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Comments
3 min read
YugabyteDB Community Open Hours: Episode 1, In The Beginning...

YugabyteDB Community Open Hours: Episode 1, In The Beginning...

Comments
1 min read
Generate SQL Script in PostgreSQL

Generate SQL Script in PostgreSQL

1
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes

pg_hint_plan in views? No. But in UDFs, Yes

2
Comments
10 min read
Install extensions from PGDG repo to YugabyteDB in Alma8

Install extensions from PGDG repo to YugabyteDB in Alma8

Comments
2 min read
Generate Random Text Strings in PostgreSQL

Generate Random Text Strings in PostgreSQL

2
Comments
1 min read
Unwrap Oracle Home .plb

Unwrap Oracle Home .plb

Comments
1 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability

“Multi-AZ” in Amazon RDS and how it may differ from High Availability

7
Comments
12 min read
Importing from Oracle Edition Based Redefinition (EBR) to YugabyteDB

Importing from Oracle Edition Based Redefinition (EBR) to YugabyteDB

Comments
3 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable

TiDB: Distributed MySQL with Foreign Key but not Serializable

Comments
5 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

7
Comments
10 min read
How ACID is CitusDB?(compared to YugabyteDB)

How ACID is CitusDB?(compared to YugabyteDB)

Comments
4 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

Comments
8 min read
YugabyteDB: Achieving High Availability and Disaster Recovery with Two Data Centers

YugabyteDB: Achieving High Availability and Disaster Recovery with Two Data Centers

Comments
12 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

1
Comments
5 min read
Scalable bounded COUNT DISTINCT in YugabyteDB

Scalable bounded COUNT DISTINCT in YugabyteDB

Comments
6 min read
UPSERT in YugabyteDB

UPSERT in YugabyteDB

2
Comments
6 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

1
Comments
4 min read
YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

1
Comments
2 min read
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
loading...