DEV Community

Franck Pachot profile picture

Franck Pachot

đŸ”¶AWS Data Hero, đŸ…ŸOracle ACED & OCM, 🐘PostgreSQL fan, 😎 SQL fan, and Developer Advocate 🚀 YugabyteDB - open-source distributed SQL database

Work

Developer Advocate at Yugabyte

Quick 📾 on 🐘 active SQL from pg_stat_statements

Quick 📾 on 🐘 active SQL from pg_stat_statements

Comments
3 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

Reactions 1 Comments
12 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

Reactions 2 Comments
6 min read
🌎🌍🌏 Yugabyte cross-continent deployment 🚀

🌎🌍🌏 Yugabyte cross-continent deployment 🚀

Reactions 1 Comments
11 min read
Yugabyte COPY batch size

Yugabyte COPY batch size

Reactions 1 Comments
4 min read
Text Search example with the OMDB sample database

Text Search example with the OMDB sample database

Reactions 1 Comments
7 min read
Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

Reactions 8 Comments
5 min read
Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

Reactions 3 Comments
8 min read
kokizzu/hugedbbench

kokizzu/hugedbbench

Reactions 1 Comments
12 min read
ORDER BY is mandatory in SQL to get a sorted result

ORDER BY is mandatory in SQL to get a sorted result

Reactions 31 Comments
6 min read
🚀 Think about Primary Key & Indexes before anything else 🐘

🚀 Think about Primary Key & Indexes before anything else 🐘

Reactions 52 Comments
8 min read
Open-source🍃MongoDB API to 🚀YugabyteDB with đŸ„­MangoDB proxy

Open-source🍃MongoDB API to 🚀YugabyteDB with đŸ„­MangoDB proxy

Reactions 6 Comments
7 min read
COPY progression in YugabyteDB

COPY progression in YugabyteDB

Reactions 6 Comments
5 min read
Boost Secondary Index Queries with Index Only Scan

Boost Secondary Index Queries with Index Only Scan

Reactions 5 Comments
11 min read
CREATE INDEX in YugabyteDB: online or fast?

CREATE INDEX in YugabyteDB: online or fast?

Reactions 3 Comments
6 min read
hyper-scale multi-tenant for SaaS: an example with pgbench

hyper-scale multi-tenant for SaaS: an example with pgbench

Reactions 6 Comments
12 min read
Bulk load into PostgreSQL / YugabyteDB - psycopg2

Bulk load into PostgreSQL / YugabyteDB - psycopg2

Reactions 5 Comments
4 min read
The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

Reactions 5 Comments
8 min read
when you have millions of insert statements in a file...

when you have millions of insert statements in a file...

Reactions 28 Comments
6 min read
YugabyteDB on OKE

YugabyteDB on OKE

Reactions 1 Comments
11 min read
Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

Reactions 10 Comments
8 min read
Index Scan in YugabyteDB

Index Scan in YugabyteDB

Reactions 3 Comments
7 min read
UUID or cached sequences?

UUID or cached sequences?

Reactions 11 Comments
7 min read
Pressure Stall Information on CentOS7

Pressure Stall Information on CentOS7

Reactions 6 Comments
3 min read
Index Only Scan on Functional Indexes

Index Only Scan on Functional Indexes

Reactions 20 Comments 2
4 min read
A kind of flashback query in PostgreSQL

A kind of flashback query in PostgreSQL

Reactions 9 Comments
3 min read
pgbench --client --jobs

pgbench --client --jobs

Reactions 3 Comments
8 min read
usql on YugabyteDB

usql on YugabyteDB

Reactions 2 Comments
4 min read
Visible number of cpu on OpenVZ and LXC

Visible number of cpu on OpenVZ and LXC

Reactions 5 Comments
5 min read
VisiData to read JSON, HTML and YugabyteDB

VisiData to read JSON, HTML and YugabyteDB

Reactions 4 Comments 1
5 min read
PostgreSQL prepared statements in PL/pgSQL

PostgreSQL prepared statements in PL/pgSQL

Reactions 7 Comments
4 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

Reactions 2 Comments
6 min read
SLOB on YugabyteDB

SLOB on YugabyteDB

Reactions 2 Comments
6 min read
YugabyteDB on OCI Free Tier

YugabyteDB on OCI Free Tier

Reactions 5 Comments
3 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

Reactions 2 Comments
5 min read
HASH or RANGE in distributed databases

HASH or RANGE in distributed databases

Reactions 1 Comments
11 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

Reactions 7 Comments
5 min read
EXPLAIN ANALYZE on COUNT() pushdown

EXPLAIN ANALYZE on COUNT() pushdown

Reactions 4 Comments
7 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

Reactions 7 Comments
8 min read
Amazon RDS Oracle in Multitenant

Amazon RDS Oracle in Multitenant

Reactions 1 Comments
6 min read
PostgreSQL on AWS Graviton2: CFLAGS

PostgreSQL on AWS Graviton2: CFLAGS

Reactions 1 Comments
8 min read
AWS Aurora vs. RDS PostgreSQL on frequent commits

AWS Aurora vs. RDS PostgreSQL on frequent commits

Reactions 9 Comments
7 min read
AWS Aurora IO:XactSync is not a PostgreSQL wait event

AWS Aurora IO:XactSync is not a PostgreSQL wait event

Reactions 3 Comments
10 min read
Oracle Standard Edition on AWS ☁ socket arithmetic

Oracle Standard Edition on AWS ☁ socket arithmetic

Reactions 2 Comments
6 min read
AWS: PostgreSQL on Graviton2 with newer GCC

AWS: PostgreSQL on Graviton2 with newer GCC

Reactions 3 Comments
18 min read
An example of ORA-01152: file ... was not restored from a sufficiently old backup

An example of ORA-01152: file ... was not restored from a sufficiently old backup

Reactions 1 Comments
20 min read
DynamoDB / Aurora: sparse and partial indexes

DynamoDB / Aurora: sparse and partial indexes

Reactions 5 Comments
7 min read
Amazon DynamoDB: a r(el)ational Glossary

Amazon DynamoDB: a r(el)ational Glossary

Reactions 2 Comments
9 min read
El Carro: The Oracle Operator for Kubernetes

El Carro: The Oracle Operator for Kubernetes

Reactions 1 Comments
7 min read
K8s on Windows/VirtualBox (and a DB)

K8s on Windows/VirtualBox (and a DB)

Reactions 6 Comments
9 min read
Linux perf-top basics: understand the %

Linux perf-top basics: understand the %

Reactions 6 Comments
9 min read
Amazon Aurora: calling a lambda from a trigger

Amazon Aurora: calling a lambda from a trigger

Comments
10 min read
DynamoDB Scan: the most efficient operation 😉

DynamoDB Scan: the most efficient operation 😉

Reactions 30 Comments 3
7 min read
Pressure Stall Information on Autonomous Linux

Pressure Stall Information on Autonomous Linux

Comments
9 min read
PostgreSQL on Linux: what is cached?

PostgreSQL on Linux: what is cached?

Reactions 1 Comments
9 min read
Grafana, SQL and IN() list for multi-value variable

Grafana, SQL and IN() list for multi-value variable

Reactions 1 Comments
5 min read
AWS: PostgreSQL on Graviton2

AWS: PostgreSQL on Graviton2

Reactions 8 Comments
5 min read
Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

Recovery in the ☁ with Google Cloud SQL (PostgreSQL)

Reactions 2 Comments
22 min read
Aurora Serverless v2 (preview) - CPU

Aurora Serverless v2 (preview) - CPU

Reactions 2 Comments
8 min read
Aurora Serverless v2 (preview) - RAM

Aurora Serverless v2 (preview) - RAM

Reactions 6 Comments
12 min read
loading...