Recently, I had a situation where I needed to think how I was using Postgres indexes. I had a simple Book table with the following schema… >d book Table "shopping.book" Column | Type | Modifiers ---------------------+------------------------+----------- id | uuid | not null version | bigint | not null amount_minor_units | integer | not null currency ...