Hi all,
Our loraserver database is very huge (nearly 80 gigabytes) and I investigated why it uses so much space and discovered the gateway_stats has more than 331 millions records.
This table seems to have only stats about gateway traffic so I suppose it can be purged safely and easily.
But before break all our production network server, I would like to have confirmation I can run a such query : DELETE FROM gateway_stats WHERE timestamp < date_trunc('day', NOW() - interval '1 month')
or totally truncate the table (we need to migrate the database server) ?
Many thanks