All news

Shard keys should come from your access patterns, not your tables: co-locating orders with customers by customer_id avoids cross-shard joins in sharded Postgres.

Postgres ON DELETE CASCADE can delete huge row counts in one transaction, causing long locks and surprises, so explicit batched deletes are safer.