As RAM limitation, if set chunk_time_interval by hour is okay please

TimescaleDB and PostgreSQL
1

Hi guys

Now our production RAM is 8GB
As “We recommend setting the chunk_time_interval so that 25% of main memory can store one chunk” in the doc, then need to set chunk_time_interval to 1 hour to meet it, is it okay please? If configure chunk_time_interval to 1 hour is okay, is there any notices to use other features please? Thank you

2

Hi @Yi_Sun , yes, that’s ok! It will depend on how much data you have to have a big impact.

If you have smaller chunks and want to query longer ranges of periods, maybe that will have an extra overhead, but for compressing and decompressing it will be very fast.

You can also use set_chunk_time_interval and change it dynamically if you see it’s not very effective.