Write positions to separate database tables for each device
Hi, i think you can use the table partition feature of postgres.
For date series data it is a good idea to partition table by range not by device, but it is up to you.
I think this is not related to traccar software, it is a feature you need to configure in the database
Partitioning is what you should do instead of reinventing the wheel.
Hi. I want to write positions to separated tables in PostgreSQL database by next structure: for each device, create a table with name like device_positions_{deviceid} and with structure similar to tc_positions. I think it is a better way for storing large amount of data in database.
Can I configure Traccar to store positions by this way using configuration file?