YugabyteDB 2.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 11.2-YB-2.6.20.0-b0 on x86_64-pc-linux-gnu, compiled by gcc (Homebrew gcc 5.5.0_4) 5.5.0, 64-bit

SELECT 1

-- YugabyteDB shards a table into tablets, and you can ask for a count
create table item (k int primary key, name text) split into 4 tablets;
insert into item values (1,'alpha'),(2,'beta'),(3,'gamma');

CREATE TABLE

INSERT 0 3

select * from item order by k;

k
name

1
alpha

2
beta

3
gamma

SELECT 3