Hey Jozef,

I wouldent use a BRIN for PK.

B-Tree indexes can be larger but they do a very good job at finding specific ID’s — especially when the column is unique. For this reason databases use B-Tree index to enforce primary keys.