2 things to add:

- I'd decouple the database writes with a message queue.

- Make sure that table is partitioned if you haven't. TimescaleDB's hyper tables are a good compromise here if you are already using Postgres..