Articles by Tag #distributed
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Aurora Limitless - Creation
Announced last year at re:Invent 2023, Aurora Limitless (PostgreSQL compatible) is available in...
Document data modeling to avoid write skew anomalies
In a previous post, I explained that a serializable isolation level is not the only solution to avoid...
AWS re:Invent 2024 - Which sessions I'll try to attend.
I've reviewed the AWS re:Invent 2024 catalog and noted my favorite sessions. The "Reserve a Seat"...
DynamoDB-style Limits for Predictable SQL Performance?
I compare Aurora DSQL to DynamoDB rather than other SQL databases. One reason DynamoDB ensures...
Amazon Aurora DSQL: Which PostgreSQL Service Should I Use on AWS ?
The Amazon Aurora innovations announced at re:Invent 2024 may leave you feeling overwhelmed when...
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client
A Distributed SQL database service was announced at AWS re:Invent 2024 and is currently available in...
When to replace IN() with EXISTS() - correlated and uncorrelated subqueries
If someone suggests rewriting your SQL query to use EXISTS instead of an IN subquery, look at the...
Large IntentsDB MemTable with Many Small SST Files
An SQL transaction comprises many sequential reads and writes that affect different objects. These...
RocksDB, Key-Value Storage, and Packed Rows: the backbone of YugabyteDB's distributed tablets flexibility
The LSM Tree implementation in YugabyteDB is based on RocksDB, a highly customizable datastore widely...
Aurora DSQL: How it Compares to YugabyteDB
This was originally posted on the Yugabyte blog and details the Aurora DSQL Disaggregated...
⛔ ORDER BY in Subquery
Here is a quick post to show the danger of not understanding how SQL and ORDER BY works. In...
Reverse Proxy and Load Balancing: Do we need both?
In this guide, I’ll walk you through configuring Nginx as both a reverse proxy and a load balancer,...
Distributing PostgreSQL on Amazon Elastic Kubernetes
After attending the Global AWS Heroes Summit in Seattle, I'm traveling though US and going to present...
Implementing “Get or Create” in YugabyteDB (or PostgreSQL)
In SQL, you can perform a "Get or Create" operation using a WITH clause, where each operation is a...
What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")
In a previous post, I briefly mentioned that I consider a NULL in SQL databases as an existing but...
Find hotspots with Yugabyte Active Session History
In a previous post, I explained that the default PgBench workload is not scalable, with all sessions...
pgSphere and Q3C on Distributed SQL
To explore YugabyteDB’s capabilities in handling spherical and astronomical datasets, I recently...
SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes
The two query APIs in YugabyteDB are YSQL, which is compatible with PostgreSQL, and YCQL, which is...
PostgreSQL plan_cache_mode
Here is a small test case to demonstrate plan_cache_mode, a PostgreSQL 12 feature available in...
Use Cases of Blockchain in Supply Chain Management: What Are the Benefits?
A supply chain is a process in which different individuals, organizations, activities, and technology...
More details in pg_locks for YugabyteDB
One benefit of Wait-on-Conflict concurrency control, also known as pessimistic locking, is its...
Multi-Statement SQL for reducing write latency in YugabyteDB (and PostgreSQL alternative to INSERT ALL)
In this article, I'll discuss different methods for running multiple SQL statements: a...
UUIDv7 in YugabyteDB
When creating a user-defined function for inserts, such as one that generates a default value, you...
Pessimistic locking, Read Committed, and all Isolation Levels
Optimistic Concurrency Control looks attractive in a distributed system because it avoids locks....
Parallel JavaScript Machine
Author: Vladas Saulis, PE Prodata, Klaipėda, Lithuania May 18th, 2024 Abstract This paper presents...
Different Roles for Read Replicas in PostgreSQL and YugabyteDB
Enterprises have not waited for distributed SQL to start scaling out their databases. In cloud...
🧵10 Facts About YugabyteDB: Misconceptions Debunked
I've noticed misunderstandings and inaccuracies about YugabyteDB in various papers and presentations....
Fault Tolerance with Raft and no Single Point of Failure
The two layers, SQL processing and distributed storage, are deployed in one binary: yb-server. The...
What's behind the Call Home option?
When you start YugabyteDB using the yugabyted command, there's a --callhome option set to true by...
IN() Index Scan in PostgreSQL 17 and YugabyteDB LSM Tree
TL;DR: This optimization in PG17 was made for B-tree indexes. YugabyteDB uses LSM Tree indexes and...