docs.timescale.com-content icon indicating copy to clipboard operation
docs.timescale.com-content copied to clipboard

Published 20 hours ago • verified publisher icon timescale

Describe the best practice of choosing time dimension column

Open k-rus opened this issue 4 years ago • 1 comments

Users sometimes have several time columns in their tables and they wonder, which is of them to chose for time dimension during hypertable creation. Recommendations for choosing the time dimension seems to be missing in best practice. Actually I failed to find any place where we explain that time should increase monotonically and the column is commonly included in to queries so chunk exclusion can happen.

k-rus avatar Apr 09 '20 08:04 k-rus

I was just thinking about a related question, which I am seeing quite often on external Q&A board: "What is the best way to store timestamps in Postgres"?

I can work on both content (one is probably a product concept, the second a tutorial). Thoughts?

akulkarni avatar Apr 09 '20 15:04 akulkarni