Why don't consider using another database that would fit better for your data? e.g. Clickhouse seems to be a good choice for event data