Articles by Tag #yugabytedb
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
A brief example of an SQL serializable transaction
Here are some additional details about a small live demo I presented while discussing Isolation...
Performance of range queries in B-Tree and LSM indexes
Range queries are efficient with B-Tree indexes because they can quickly locate the starting value...
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...
Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL
In a previous post, I detailed the differences in Exception Handling between Oracle and PostgreSQL....
Unique Index on NULL Values in SQL & NoSQL
NoSQL behavior: MongoDB SQL behavior: PostgreSQL and YugabyteDB A mix of both: Oracle Database You...
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...
Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB
Lot of companies hope to find a solution to easily move their PL/SQL code from Oracle Database to...
ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index
Yesterday at the PostgreSQL Meetup in Suisse Romande, Lucy Linder discussed exciting challenges...
Aurora DSQL - Simple Inserts Workload from an AWS CloudShell
My first test of Amazon Aurora DSQL focuses on read and write latency using an existing Java...
ESR (Equality, Sort, Range) rule applied to YugabyteDB and PostgreSQL indexes
TL;DR: To make developers' lives easier, MongoDB has documented a simple rule for creating an...
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...
Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers
PostgreSQL offers significant improvements beyond single-column indexing, which YugabyteDB also...
You Probably Don't Need Serializable Isolation
In my previous post, I provided an example of a serializable transaction. I discussed how Oracle...
Large IntentsDB MemTable with Many Small SST Files
An SQL transaction comprises many sequential reads and writes that affect different objects. These...
Write Buffering to Reduce Raft Consensus Latency in YugabyteDB
YugabyteDB is an open-source distributed SQL database that is compatible with PostgreSQL. It...
Aurora DSQL: How it Compares to YugabyteDB
This was originally posted on the Yugabyte blog and details the Aurora DSQL Disaggregated...
Indexing for NOT EQUAL (<>,!=) in YugabyteDB, PostgreSQL, Oracle Database, SQL Server, and MongoDB
Indexing for Not-Equal in YugabyteDB Indexing for Not-Equal in PostgreSQL Indexing for Not-Equal in...
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...
Indexing for a Scalable Serialization Isolation Level
The previous post used the primary key to record read intents in YugabyteDB. Serializable isolation...
Distributing PostgreSQL on Amazon Elastic Kubernetes
After attending the Global AWS Heroes Summit in Seattle, I'm traveling though US and going to present...
⛔ ORDER BY in Subquery
Here is a quick post to show the danger of not understanding how SQL and ORDER BY works. In...
Observing CPU/RAM/IO pressure in YugabyteDB with Linux PSI on AlmaLinux8 (Pressure Stall Information)
Pressure Stall Information is a Linux kernel metric that accounts for when the OS tasks are waiting...
PostgreSQL plan_cache_mode
Here is a small test case to demonstrate plan_cache_mode, a PostgreSQL 12 feature available in...
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...
pgSphere and Q3C on Distributed SQL
To explore YugabyteDB’s capabilities in handling spherical and astronomical datasets, I recently...
Batching and Push-Downs to Distribute with High-Performance reads and writes
It wouldn't be efficient to read all rows scanned by a query and replicate each write synchronously...
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...
Find hotspots with Yugabyte Active Session History
In a previous post, I explained that the default PgBench workload is not scalable, with all sessions...
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...
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew
In his book "Designing Data-Intensive Applications", Martin Kleppmann explains the concept of...