DEV Community

Franck Pachot profile picture

Franck Pachot

Developer Advocate 🚀 YugabyteDB - postgres compatible open-source distributed SQL database đŸ”¶AWS Data Hero, đŸ…ŸOracle ACE Alumni & OCM, 🐘 PostgreSQL fan

Location Lausanne, Switzerland Joined Joined on  Personal website https://www.linkedin.com/in/franckpachot github website twitter website

Education

France

Work

Developer Advocate at Yugabyte

Bitmap Scan in YugabyteDB

Bitmap Scan in YugabyteDB

Comments
8 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
YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

1
Comments
7 min read
Transaction Internals: Fast Path vs Multi-Shard

Transaction Internals: Fast Path vs Multi-Shard

Comments
1 min read
The cost of additional secondary indexes in PostgreSQL & YugabyteDB

The cost of additional secondary indexes in PostgreSQL & YugabyteDB

Comments
6 min read
Postgres Join Methods in YugabyteDB

Postgres Join Methods in YugabyteDB

Comments
12 min read
ACID properties explained to NoSQL vendors

ACID properties explained to NoSQL vendors

Comments
4 min read
JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

2
Comments
11 min read
PL/Python in YugabyteDB

PL/Python in YugabyteDB

1
Comments
3 min read
pg_stat_activity from all servers in YugabyteDB

pg_stat_activity from all servers in YugabyteDB

9
Comments
3 min read
No-gap sequence in PostgreSQL and YugabyteDB

No-gap sequence in PostgreSQL and YugabyteDB

6
Comments
4 min read
YugabyteDB is Distributed SQL: resilient and consistent

YugabyteDB is Distributed SQL: resilient and consistent

9
Comments
6 min read
Citus is not ACID but Eventually Consistent

Citus is not ACID but Eventually Consistent

1
Comments
6 min read
YugabyteDB official Dockerfile

YugabyteDB official Dockerfile

7
Comments
2 min read
Counters with YugabyteDB

Counters with YugabyteDB

8
Comments
2 min read
pg-hostname on YugabyteDB compiled and installed directly on the server

pg-hostname on YugabyteDB compiled and installed directly on the server

5
Comments
3 min read
FlameGraphs on Steroids with profiler.firefox.com

FlameGraphs on Steroids with profiler.firefox.com

1
Comments
3 min read
Another funny benchmark: "hugedbbench"

Another funny benchmark: "hugedbbench"

Comments
3 min read
SQL for low code applications: SQLPage

SQL for low code applications: SQLPage

1
Comments
2 min read
PostgreSQL Optimizer Hints Discussion

PostgreSQL Optimizer Hints Discussion

2
Comments
5 min read
Understand what you run before publishing your (silly) benchmark results

Understand what you run before publishing your (silly) benchmark results

1
Comments
16 min read
YugabyteDB: set read-only for a single query to allow follower reads

YugabyteDB: set read-only for a single query to allow follower reads

Comments
8 min read
Query Amazon Redshift from YugabyteDB though PostgreSQL Foreign Data Wrapper and VPC peering

Query Amazon Redshift from YugabyteDB though PostgreSQL Foreign Data Wrapper and VPC peering

1
Comments
7 min read
Book review: Mastering PostgreSQL 15

Book review: Mastering PostgreSQL 15

1
Comments
5 min read
Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

Comments
6 min read
Quickly testing an extension from docker image

Quickly testing an extension from docker image

Comments
2 min read
wiki.js on YugabyteDB

wiki.js on YugabyteDB

Comments
3 min read
How to Select the First Row of Each Set of Grouped Rows Using GROUP BY

How to Select the First Row of Each Set of Grouped Rows Using GROUP BY

1
Comments
1 min read
YugabyteDB fast path write

YugabyteDB fast path write

1
Comments
9 min read
Global Unique Constraint on a partitioned table in PostgreSQL and YugabyteDB

Global Unique Constraint on a partitioned table in PostgreSQL and YugabyteDB

Comments
7 min read
How to Check Your PostgreSQL Version

How to Check Your PostgreSQL Version

1
Comments
1 min read
Indexing for LIKE Queries in PostgreSQL

Indexing for LIKE Queries in PostgreSQL

1
Comments
1 min read
Indexing JSON in PostgreSQL

Indexing JSON in PostgreSQL

Comments
1 min read
One fat index, or two indexes on each columns? PostgreSQL vs. YugabyteDB

One fat index, or two indexes on each columns? PostgreSQL vs. YugabyteDB

1
Comments
8 min read
Approximate COUNT YugabyteDB Community Open Hours: Episode 2: Extensions and Smart Driver

Approximate COUNT YugabyteDB Community Open Hours: Episode 2: Extensions and Smart Driver

Comments
1 min read
PGLOADBALANCEHOSTS

PGLOADBALANCEHOSTS

Comments
4 min read
UPDATE RETURNING OLD | NEW in YugabyteDB and PostgreSQL

UPDATE RETURNING OLD | NEW in YugabyteDB and PostgreSQL

4
Comments 2
1 min read
connecting with psql 16 beta to YugabyteDB and use the most recent features

connecting with psql 16 beta to YugabyteDB and use the most recent features

1
Comments 2
4 min read
Compile pg_math for YugabyteDB (wrapper on GNU Scientific Library distribution functions)

Compile pg_math for YugabyteDB (wrapper on GNU Scientific Library distribution functions)

1
Comments
2 min read
DROP TABLE while being read: wait or wound?

DROP TABLE while being read: wait or wound?

1
Comments
8 min read
Approximate Count for hash sharded YugabyteDB tables

Approximate Count for hash sharded YugabyteDB tables

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