Overheard @ Office Hours
A selection of FAQs from Timescale Office Hours. During our last session we discussed schema creation, hardware requirements, migrating to Timescale Cloud and more.
We had a great office hours session last week with attendees in various spaces including fintech, AI, and IoT. This month, we are hosting two more office hours on August 15 at 4pm ET and August 30 at 9am ET. You can sign up for one of these sessions here.
Below, we will share a selection of questions and answers from last week.
In terms of creating a schema, is there a difference between creating it in PostgreSQL vs. TimescaleDB?
There are only two differences when creating a schema in TimescaleDB. The first is that any unique key you have on your hypertable needs to include a time field. The second is that you can not have a foreign key within a hypertable, but you can have one outside of it.
Is there an option to change your chunk size in the future?
Yes, but you will want to set it in terms of the amount of time a chunk contains. We say your chunk sizes should fit into ¼ of your memory because with heavy operational workloads, you want to ensure that your b-trees that are being updated can fit in memory.
If we create a separate unit key for a particular entry, will this speed up query time?
It depends on the type of query you are working with. In most cases, if you have a unique key or index, it will speed up the query.
Do you have any recommendations for speccing hardware requirements?
Your hardware requirements will depend heavily on the types of queries and the percentage of your dataset that can fit in memory. Some of our benchmarking blog posts might be relevant to your use case (here and here), but otherwise, we suggest getting in touch with us via Slack to discuss further.
We are concerned about scaling in the future. Is it easy to move from PostgreSQL (non-hosted) to Timescale Cloud?
Yes! You can use pg_dump and restore your data on Timescale Cloud using a tool such as psql. In the future, within Timescale Cloud you can upgrade your instance with just one click and minimal downtime.