Don't forget PostgreSQL extensions. For something like a chat log, TimescaleDB (https://www.timescale.com/ https://www.timescale.com/) can be surprisingly effic

Don't forget PostgreSQL extensions. For something like a chat log, TimescaleDB (https://www.timescale.com/ https://www.timescale.com/) can be surprisingly efficient. It will handle partitioning for you, with additional features like data reordering, compression, and retention policies.