# distributed

10 min read

Franck Pachot for YugabyteDB

Apr 27

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

#postgres #yugabytedb #distributed #sql

10 min read

Franck Pachot for YugabyteDB

Apr 9

Scalable bounded COUNT DISTINCT in YugabyteDB

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for YugabyteDB

Apr 3

UPSERT in YugabyteDB

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Apr 2

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

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Mar 19

YugabyteDB column-level locking for UPDATE

#yugabytedb #distributed #sql #lock

2 min read

Franck Pachot for YugabyteDB

Mar 16

Retype a column in YugabyteDB (and PostgreSQL)

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot for YugabyteDB

Mar 14

Scalable sequences in PostgreSQL / YugabyteDB

#yugabytedb #distributed #sql #postgres

3 min read

Franck Pachot for YugabyteDB

Mar 2

Foreign keys referencing partitioned tables in YugabyteDB

#yugabytedb #partitioning #distributed #foreignkey

7 min read

Franck Pachot for YugabyteDB

Feb 8

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

#yugabytedb #postgres #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Jan 26

YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

#distributed #sql #transaction #yugabytedb

5 min read

Federico Kauffman

Jan 16

CRDTs and Distributed Consistency - Part 2: Building a distributed counter

#crdts #distributed #consistency

7 min read

Federico Kauffman

Jan 16

CRDTs and Distributed Consistency - Part 3: Building a distributed counter

#crdts #distributed #consistency

6 min read

Federico Kauffman

Jan 16

CRDTs and Distributed Consistency - Part 1: Building a distributed counter

#crdts #distributed #consistency

6 min read

Franck Pachot for YugabyteDB

Jan 7

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

#yugabytedb #sql #distributed #database

8 min read

Franck Pachot for YugabyteDB

Jan 6

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

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot

Dec 12 '22

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

#yugabytedb #postgres #explain #distributed

3 min read

Franck Pachot for YugabyteDB

Dec 20 '22

A very short demo on updates in YugabyteDB

#yugabytedb #postgres #sql #distributed

3 min read

Franck Pachot

Nov 1 '22

YugabyteDB cloud/region/zone

#yugabytedb #geo #distributed #sql

4 min read

Wahid Abduhakimov

Nov 25 '22

Memory Cache in .NET

#redis #cache #distributed #uzbek

13

2 min read

Franck Pachot for YugabyteDB

Nov 17 '22

YugabyteDB auto-sharding (showing tablet size with Grafana)

#yugabytedb #distributed #sql #sharding

4

8 min read

Franck Pachot for YugabyteDB

Nov 9 '22

MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

#distributed #sql #mysql #database

8 min read

Franck Pachot for YugabyteDB

Nov 7 '22

Gitpod with YugabyteDB image

#gitpod #yugabytedb #postgres #distributed

2 min read

Franck Pachot for YugabyteDB

Nov 4 '22

Mastodon on YugabyteDB

#mastodon #yugabytedb #postgres #distributed

6

4 min read

Franck Pachot for YugabyteDB

Nov 1 '22

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

#yugabytedb #distributed #sql #database

5 min read

Abhishek Mishra for YugabyteDB

Oct 11 '22

How to Avoid Cloud Outages with YugabyteDB for Python Apps

#python #yugabytedb #database #distributed

7 min read

Franck Pachot for YugabyteDB

Sep 12 '22

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

#yugabytedb #postgres #distributed #sql

4

6 min read

Franck Pachot

Sep 5 '22

SingleStore compared to YugabyteDB

#singlestore #memsql #yugabytedb #distributed

6 min read

Franck Pachot for YugabyteDB

Sep 1 '22

Read local partition first, then global if not found locally

#sql #distributed #database #yugabytedb

7 min read

Franck Pachot for YugabyteDB

Aug 19 '22

Parallelizing aggregates in YugabyteDB

#yugabytedb #distributed #sql #count

4 min read

Franck Pachot for YugabyteDB

Aug 18 '22

Fastest start of YugabyteDB for a small lab

#yugabytedb #microvm #distributed #sql

2 min read

Franck Pachot for YugabyteDB

Jul 25 '22

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

#yugabytedb #distributed #sql #database

12

3 min read

Franck Pachot for YugabyteDB

Jul 25 '22

Default tablet splitting in YugabyteDB 🚀

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for AWS Heroes

Jul 18 '22

IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

#yugabytedb #iot #postgres #distributed

4 min read

Franck Pachot

Jul 15 '22

🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

#yugabytedb #troubleshooting #distributed #database

6

5 min read

Franck Pachot for YugabyteDB

Jul 13 '22

find the partition key with a duplicate covering index local read

#yugabytedb #distributed #sql #database

9

8 min read

Franck Pachot for YugabyteDB

Jul 13 '22

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

#yugabyted #distributed #sql #database

12

4 min read

Franck Pachot

Jul 5 '22

The YugabyteDB configuration parameters (GFLAGs and GUCs)

#yugabytedb #postgres #distributed #database

5 min read

Franck Pachot for YugabyteDB

Jul 4 '22

Optimizing Nested Loop joins on YugabyteDB with jOOQ

#yugabytedb #jooq #sql #distributed

8

4 min read

Franck Pachot for YugabyteDB

Jun 30 '22

geo-distribution with 🚀 YugabyteDB tablespaces

#yugabytedb #distributed #postgres #sql

9

4 min read

Franck Pachot for YugabyteDB

Jun 27 '22

Local reads from 🚀YugabyteDB raft followers

#yugabytedb #distributed #postgres #sql

6 min read

Franck Pachot for YugabyteDB

Jun 27 '22

Local reads from 🚀YugabyteDB Read Replicas

#yugabytedb #distributed #postgres #sql

7 min read

Franck Pachot for YugabyteDB

Jun 22 '22

🚀 hash+hash partitioning+sharding

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for YugabyteDB

Jun 12 '22

Nested Loop performance in YugabyteDB

#yugabytedb #distributed #sql #database

12 min read

Franck Pachot for YugabyteDB

Jun 7 '22

Quickly get short stack from a YugabyteDB tserver

#yugabytedb #distributed #sql #database

2 min read

Franck Pachot for YugabyteDB

Jun 3 '22

ERROR: Timed out: BackfillIndex RPC

#yugabytedb #distributed #sql #database

8

3 min read

Franck Pachot for YugabyteDB

Jun 2 '22

YugabyteDB Predicate Push Down

#yugabytedb #sql #distributed #database

6 min read

Franck Pachot for YugabyteDB

Jun 1 '22

1 million rows insert

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Jun 1 '22

🔓 tracing writes and locks in YugabyteDB

#yugabytedb #distributed #sql #lock

6

6 min read

Franck Pachot for YugabyteDB

May 21 '22

"I want to try it" 🚀 YugabyteDB at KubeCon

#kubecon #distributed #sql #yugabytedb

11

3 min read

Franck Pachot for YugabyteDB

May 16 '22

🐘OID <-> 🚀table_id

#yugabytedb #distributed #sql #database