# yugabytedb

7 min read

Franck Pachot

Dec 12 '22

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

#yugabytedb #postgres #distributed #database

3 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Dec 9 '22

Size matters...for arrays

#yugabytedb #postgres #plpgsql

5 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Dec 9 '22

YugabyteDB: list failed commands

#yugabytedb #postgres

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 8 '22

What is a "truly distributed UDF" ?

#yugabytedb #postgres #udf #sql

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 7 '22

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #aggregate #database

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 5 '22

Index usage monitoring in YugabyteDB & PostgreSQL

#yugabytedb #postgres #index #monitoring

11 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 2 '22

Scalable Job Queue in SQL (YugabyteDB)

#yugabytedb #sql #queue #scalability

21

5 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Dec 2 '22

YugabyteDB Yedis

#yugabytedb #redis #deprecated

2 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Dec 1 '22

LSM-tree storage in YugabyteDB and packed rows

#yugabytedb #lsmtree #rocksdb

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 30 '22

The best indexes for an execution plan that never gets (too) wrong

#sql #database #yugabytedb #optimizer

15 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 22 '22

DuckDB on YugabyteDB

#yugabytedb #olap #htap #duckdb

5 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Nov 22 '22

PostgreSQL and YugabyteDB partitioning and indexes

#postgres #yugabytedb #performance #sql

7 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 20 '22

Cross-cluster async replication with YugabyteDB xCluster

#yugabytedb #asynchronous #replication #cluster

6 min read

Frits Hoogland for YugabyteDB Distributed PostgreSQL Database

Nov 19 '22

PostgreSQL do different equality predicates make a difference?

#yugabytedb #postgres #performance #sql

9

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 17 '22

YugabyteDB auto-sharding (showing tablet size with Grafana)

#yugabytedb #distributed #sql #sharding

8 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 15 '22

Flashback query in YugabyteDB

#yugabytedb #flashback #query #sql

6 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 8 '22

LSM Tree, Tombstones and YugabyteDB (No Vacuum)

#yugabytedb #lsm #distributed #database

9 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 8 '22

YugabyteDB on OKE: testing batch size for bulk load

#yugabytedb #oracle #oci #kubernetes

8 min read

Denis Magda for YugabyteDB Distributed PostgreSQL Database

Nov 7 '22

Geo-Distributed Microservices and Their Database: Fighting the High Latency

#yugabytedb #distributedsql #cloud #distributedsystems

12 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 7 '22

Gitpod with YugabyteDB image

#gitpod #yugabytedb #postgres #distributed

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 4 '22

Mastodon on YugabyteDB

#mastodon #yugabytedb #postgres #distributed

4 min read

Brett Hoyer for YugabyteDB Distributed PostgreSQL Database

Nov 3 '22

How to Improve Node.js Application Latency Using Different Distributed SQL Deployments

#yugabytedb #postgres #node #javascript

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Nov 1 '22

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Nov 1 '22

YugabyteDB cloud/region/zone

#yugabytedb #geo #distributed #database

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Oct 31 '22

How to set Read Committed in YugabyteDB

#yugabytedb #postgres #isolation #sql

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Oct 19 '22

YugabyteDB Skip Scan aka Loose Index Scan on compound index

#yugabytedb #postgres #sql #database

5 min read

Denis Magda for YugabyteDB Distributed PostgreSQL Database

Oct 18 '22

Geo-Distributed API Layer With Kong Gateway

#api #distributedsystems #googlecloud #yugabytedb

7 min read

Abhishek Mishra for YugabyteDB Distributed PostgreSQL Database

Oct 11 '22

How to Avoid Cloud Outages with YugabyteDB for Python Apps

#python #yugabytedb #database #distributed

7 min read

Brett Hoyer for YugabyteDB Distributed PostgreSQL Database

Oct 10 '22

Developing a Node.js Application in a Virtual Private Cloud

#node #javascript #webdev #yugabytedb

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Oct 4 '22

pg_hint_plan: Get the right plan without surprises

#postgres #yugabytedb #hint #sql

1 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Oct 3 '22

Real Application Testing on 🚀YugabyteDB 🐘pgreplay

#postgres #yugabytedb #rat #replay

4 min read

Abhishek Mishra for YugabyteDB Distributed PostgreSQL Database

Sep 28 '22

How to Build a Scalable Streaming App with Django, Celery & YugabyteDB

#postgres #yugabytedb #django #celery

8 min read

Franck Pachot

Sep 28 '22

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

#aws #aurora #yugabytedb #sql

7 min read

Abhishek Mishra for YugabyteDB Distributed PostgreSQL Database

Sep 19 '22

Building An Application with YugabyteDB and Flask

#postgres #database #yugabytedb #python

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Sep 17 '22

pg_stat_statements with pg_hint_plan

#postgres #yugabytedb #sql #database

3 min read

Brett Hoyer for YugabyteDB Distributed PostgreSQL Database

Sep 16 '22

Deploying a Node.js application across multiple geographies with Terraform and Ansible

#ansible #terraform #webdev #yugabytedb

8

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Sep 12 '22

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

#yugabytedb #postgres #distributed #sql

9

6 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Sep 6 '22

Nakama with YugabyteDB

#yugabytedb #docker #compose #nakama

2 min read

Franck Pachot

Sep 5 '22

SingleStore compared to YugabyteDB

#singlestore #memsql #yugabytedb #distributed

6 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Sep 1 '22

Read local partition first, then global if not found locally

#sql #distributed #database #yugabytedb

7 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Aug 31 '22

Fixing Docker image vulnerabilities (with centos2ol.sh)

#docker #cve #yugabytedb #centos

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Aug 30 '22

YugabyteDB in a Micro VM with no network

#yugabytedb #microvm #firecracker #database

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Aug 19 '22

Parallelizing aggregates in YugabyteDB

#yugabytedb #distributed #sql #count

4 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Aug 18 '22

Fastest start of YugabyteDB for a small lab

#yugabytedb #microvm #distributed #database

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Aug 10 '22

Bookmarklet for YugabyteDB table's tablets

#yugabytedb #css #distrtibuted #sql

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 31 '22

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

#yugabytedb #postgres #mongodb #database

4 min read

Brett Hoyer for YugabyteDB Distributed PostgreSQL Database

Jul 28 '22

Automating Infrastructure For Geo-Distributed Applications With Terraform

#terraform #yugabytedb #distributedsql #googlecloud

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 26 '22

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

#postgres #yugabytedb #skipscan #looseindex

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 25 '22

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

#yugabytedb #distributed #sql #database

12

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 25 '22

Default tablet splitting in YugabyteDB 🚀

#yugabytedb #distributed #sql #database

6 min read

Abhishek Mishra for YugabyteDB Distributed PostgreSQL Database

Jul 22 '22

Deploying FastAPI Python Application with YugabyteDB to Heroku

#fastapi #postgres #yugabytedb #database

5 min read

Denis Magda for YugabyteDB Distributed PostgreSQL Database

Jul 20 '22

Distributing Data Across Distant Locations With Table Geo-Partitioning

#yugabytedb #postgres #architecture #database

8 min read

Franck Pachot

Jul 20 '22

📜 select * from 🚀 logfile with 🐘 file_fdw

#yugabytedb #troubleshooting #logfile #fdw

2 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 20 '22

YugabyteDB cardinality estimation in the absence of ANALYZE statistics

#yugabytedb #optimizer #planner #database

9 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 18 '22

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

#yugabytedb #postgres #troubleshooting #strace

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

5 min read

Abhishek Mishra for YugabyteDB Distributed PostgreSQL Database

Jul 14 '22

Moving a Python Application to a Distributed Database in Three Easy Steps.

#python #postgres #yugabytedb #database

5 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jul 13 '22

find the partition key with a duplicate covering index local read

#yugabytedb #distributed #sql #database