YugabyteDB 2.18

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

select version();

version

PostgreSQL 11.2-YB-2.18.9.0-b0 on x86_64-pc-linux-gnu, compiled by clang version 15.0.7 (https://github.com/yugabyte/llvm-project.git 6b9d30d80f5cebc66c9fa46013d18f125ea8ec0e), 64-bit

SELECT 1

-- 2.18 exposes colocation per table: small tables can share one tablet
create table item (k int primary key, name text) with (colocation = false);
insert into item values (1,'alpha'),(2,'beta');

CREATE TABLE

INSERT 0 2

select * from item order by k;

k
name

1
alpha

2
beta

SELECT 2

select * from yb_table_properties('item'::regclass);

num_tablets
num_hash_key_columns
is_colocated
tablegroup_oid
colocation_id

1
1
f
null
null

SELECT 1