News for hackers. Stuff that matters.

A comment on Why Not to Build a Time-Series Database. Parent comment

Re:Why Not to Build a Time-Series Database by dub on Wednesday November 07, 2018 @08:26PM (#18403743)
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...
[ Parent | on HN ]
Re:Why Not to Build a Time-Series Database by manigandham on Wednesday November 07, 2018 @09:48PM (#18404031)
Yes, 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.

[ Parent | on HN ]
Re:Why Not to Build a Time-Series Database by anon12345690 on Thursday November 08, 2018 @12:03PM (#18407746)
the first section on that page shows what the op was saying, to use the name column first and timestamp last
[ Parent | on HN ]