YugabyteDB automatically splits YCQL user tables into multiple shards, called tablets, using a hash based strategy. You can see the tablets for a table via the […]
Read MoreDisplay Session Count on Each Node of a YSQL Database
As highlighted in Distributed PostgreSQL on a Google Spanner Architecture – Query Layer, YSQL reuses the open source PostgreSQL query layer (written in […]
Read MoreList Tablet Details for a YSQL Table From the Command Line
YugabyteDB automatically splits user YSQL tables into multiple shards, called tablets, using either a hash– or range– based strategy. You can see the Tablets […]
Read MoreEnable Upsert Mode in YSQL
In YugabyteDB‘s YSQL API, a Primary Key constraint is a means to uniquely identify a specific row in a table via one […]
Read MorePitfalls of Adding a PK to an Existing Table in YSQL
Although it’s possible to add a primary key constraint to an existing table with the ALTER TABLE ADD CONSTRAINT command, it’s best […]
Read More