Avoid UUID Version 4 Primary Keys (for Postgres)
Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad p...
Summary
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.