1) But with quite a hefty penalty on writes... I'd think you would be better off without a primary key and just using a BRIN index for that use case? 2) Even i

1) But with quite a hefty penalty on writes... I'd think you would be better off without a primary key and just using a BRIN index for that use case? 2) Even if you did really want that B-tree, you can still have it and not have to have to awkwardly make it unique if you don't make it a "primary" key.