4 ms·
A modern, distributed, relational, column-oriented database will often stress emphatically in the documentation that using timestamps as primary keys is an anti
by dub 8y ago
A modern, distributed, relational, column-oriented database will often stress emphatically in the documentation that using timestamps as primary keys is an anti-pattern that's likely to lead to hot tablets: https://cloud.google.com/spanner/docs/schema-design#choosing_a_primary_key_to_prevent_hotspots https://cloud.google.com/spanner/docs/schema-design#choosing...
- manigandham 8y agoYes, that's why my comment said use metric name and timestamp. Spanner isn't a column-oriented database, but they all support multiple columns as the primary/sort/shard/distribution key. Use the name as the first column, and timestamp as the last column, for scalable distribution.
- anon12345690 8y agothe first section on that page shows what the op was saying, to use the name column first and timestamp last