Efficient storage of large IDs in Postgres
Imagine a system that uses large-ish hex string identifiers, e.g. similar to UUIDs. To make the math easy, lets say we make a table with a million have 20 character IDs: create table ids1 (id character varying(20)); — takes 2091 ms insert into ids1 select ‘0123456789ABCDEF0123’ from generate_series(1, 1000000) num We can get the size …
Continue reading “Efficient storage of large IDs in Postgres”