I run Home Assistant as a virtual machine under Proxmox. I already have another instance under Proxmox that runs Postgres. I would like to set up a Timescale DB on the Postgres instance, and have Home Assistant log to that Timecale DB. My goal is long term storage of sensor data, analysis and data mining on top the Timescale DB.
But it is not clear to me how to achieve this on an external Timescale server.
Do I need to create some tables manually? Or can HA create them automatically for Timescale?
Can HA be set up to use Timescale instead of the built in SQLite? And can it use Timescale adapted queries for efficiency when fetching time series data?
If anyone has experience with this use-case or tips from knowledge it would be greatly appreciated.