# yugabytedb

2 min read

Frits Hoogland for YugabyteDB

Mar 16

YugabyteDB yb_stats: table and tablet detail

#yugabytedb #internals

5 min read

Franck Pachot for YugabyteDB

Mar 12

Simulate network latency in a YugabyteDB cluster, on a Docker lab

#yugabytedb #docker #network #latency

8 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 16

Retype a column in YugabyteDB (and PostgreSQL)

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot for YugabyteDB

Mar 2

Foreign keys referencing partitioned tables in YugabyteDB

#yugabytedb #partitioning #distributed #foreignkey

7 min read

Franck Pachot

Mar 4

YugabyteDB Managed CLI: provisioning a free DB from the command line

#yugabytedb #free #managed #service

3 min read

Franck Pachot for YugabyteDB

Jan 31

Testing LSM-Tree merge for Size Amplification in YugabyteDB

#yugabytedb #size #amplification #compaction

6 min read

Frits Hoogland for YugabyteDB

Jan 31

YugabyteDB advanced analysis: nonmetric diff

#yugabytedb #observability

7 min read

Frits Hoogland for YugabyteDB

Feb 20

YugabyteDB: how does a master deal with HA

#yugabytedb #highavailability

4 min read

Frits Hoogland for YugabyteDB

Jan 25

Listing active and inactive YugabyteDB connections

#yugabytedb #performance #monitoring

5 min read

Frits Hoogland for YugabyteDB

Feb 1

Watching a YugabyteDB table: replica destruction and recovery

#yugabytedb #disasterrecover

4 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

Feb 7

Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX

#oracle #postgres #yugabytedb #migration

4 min read

Franck Pachot for YugabyteDB

Feb 6

YugabyteDB Recovery Time Objective (RTO) with PgBench: continuous availability with max. 15s latency on infrastructure failure

#yugabytedb #rto #recovery #failover

10 min read

Franck Pachot for YugabyteDB

Feb 3

YugabyteDB Managed API: provisioning a free DB from command line

#yugabytedb #free #managed #service

4 min read

Franck Pachot for YugabyteDB

Jan 22

pREST on YugabyteDB

#postgres #rest #yugabytedb #ords

4 min read

Franck Pachot for AWS Heroes

Jan 19

FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

#mongodb #yugabytedb #postgres #eks

6

5 min read

Frits Hoogland for YugabyteDB

Jan 18

Watching a YugabyteDB table: tablets and replicas

#yugabytedb #ysql

9 min read

Franck Pachot for AWS Heroes

Jan 17

YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

#yugabytedb #kubernetes #database #postgres

6 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

Frits Hoogland for YugabyteDB

Dec 21 '22

PostgreSQL and YugabyteDB client execution profiling

#postgres #yugabytedb #performance

6 min read

Frits Hoogland for YugabyteDB

Jan 19

Watching a YugabyteDB table: majority failure

#yugabytedb #ysql #availability #distributedsystems

5 min read

Frits Hoogland for YugabyteDB

Jan 17

Watching a YugabyteDB table: replication factor

#yugabytedb #ysql #distributedsql

3 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 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 AWS Heroes

Jan 7

Scalable Sequence for PostgreSQL

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for YugabyteDB

Jan 4

Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

#yugabytedb #postgres #oracle #migration

5 min read

Franck Pachot for YugabyteDB

Jan 3

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

#yugabytedb #postgres #timeseries #sql

4 min read

Franck Pachot for YugabyteDB

Dec 14 '22

INSERT ON CONFLICT returning old values

#postgres #yugabytedb #sql #duplicate

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 7 '22

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #sql #aggregate

3 min read

Franck Pachot for YugabyteDB

Dec 5 '22

Index usage monitoring in YugabyteDB & PostgreSQL

#yugabytedb #postgres #index #monitoring

11 min read

Frits Hoogland for YugabyteDB

Dec 22 '22

yb_stats print log option

#yugabytedb #observability #rust

4 min read

Franck Pachot for YugabyteDB

Dec 22 '22

Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

#yugabytedb #postgres #extension #compatibility

5 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

Dec 16 '22

Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

#yugabytedb #postgres #cockroachdb #dump

9

8 min read

Frits Hoogland for YugabyteDB

Dec 15 '22

yb_stats version option

#yugabytedb #observability #rust

5 min read

Franck Pachot

Dec 14 '22

A very short demo to show YugabyteDB follower reads

#yugabytedb #ybwr #follower #consistency

2 min read

Frits Hoogland for YugabyteDB

Dec 13 '22

Measuring memory usage with yb_stats, part 1: OS memory

#yugabytedb #performance #observability

7 min read

Frits Hoogland for YugabyteDB

Dec 9 '22

Size matters...for arrays

#yugabytedb #postgres #plpgsql

5

5 min read

Frits Hoogland for YugabyteDB

Dec 9 '22

YugabyteDB: list failed commands

#yugabytedb #postgres

2 min read

Franck Pachot for YugabyteDB

Dec 8 '22

What is a "truly distributed UDF" ?

#yugabytedb #postgres #udf #sql

7

4 min read

Franck Pachot for YugabyteDB

Dec 2 '22

Scalable Job Queue in SQL (YugabyteDB)

#yugabytedb #sql #queue #scalability

21

5 min read

Frits Hoogland for YugabyteDB

Dec 2 '22

YugabyteDB Yedis

#yugabytedb #redis #deprecated

5

2 min read

Frits Hoogland for YugabyteDB

Dec 1 '22

LSM-tree storage in YugabyteDB and packed rows

#yugabytedb #lsmtree #rocksdb

5

5 min read

Franck Pachot

Nov 1 '22

YugabyteDB cloud/region/zone

#yugabytedb #geo #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Nov 30 '22

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

#sql #database #yugabytedb #optimizer

15 min read

Denis Magda for YugabyteDB

Nov 7 '22

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

#yugabytedb #distributedsql #cloud #distributedsystems

12 min read

Franck Pachot for YugabyteDB

Nov 15 '22

Flashback query in YugabyteDB

#yugabytedb #flashback #query #sql

6 min read

Franck Pachot for YugabyteDB

Nov 22 '22

DuckDB on YugabyteDB

#yugabytedb #olap #htap #duckdb

4 min read

Frits Hoogland for YugabyteDB

Nov 22 '22

PostgreSQL and YugabyteDB partitioning and indexes

#postgres #yugabytedb #performance #sql

7 min read

Franck Pachot for YugabyteDB

Nov 20 '22

Cross-cluster async replication with YugabyteDB xCluster

#yugabytedb #asynchronous #replication #cluster

6 min read

Frits Hoogland for YugabyteDB

Nov 19 '22

PostgreSQL do different equality predicates make a difference?

#yugabytedb #postgres #performance #sql

8

2 min read

Franck Pachot for YugabyteDB

Nov 17 '22

YugabyteDB auto-sharding (showing tablet size with Grafana)

#yugabytedb #distributed #sql #sharding

8 min read

Franck Pachot for YugabyteDB

Nov 8 '22

LSM Tree, Tombstones and YugabyteDB 🚀

#yugabytedb #lsm #tombstone #wal

7

9 min read

Franck Pachot for YugabyteDB

Nov 8 '22

YugabyteDB on OKE: testing batch size for bulk load

#yugabytedb #oracle #oci #kubernetes