3 ms·
Why does he define the sample schema with “series_id TEXT, timestamp integer”? Isn’t it more reasonable to use “series_id bigint, timestamp timestamptz”?
by SnowHill9902 4y ago
Why does he define the sample schema with “series_id TEXT, timestamp integer”? Isn’t it more reasonable to use “series_id bigint, timestamp timestamptz”?
- Mo3 4y agoseries_id - definitely looks like a mistake - timestamp could just be Unix time? I always use ints for unix times too, I have no hard data on that decision, but it feels like that might avoid a little bit of overhead.
- SnowHill9902 4y agoSomeone could chime in but timestamptz is just an 8 byte integer like a bigint.