Lemmy PostgreSQL
RoundSparrow
•
1y ago
•
100%
HOT updates in PostgreSQL for better performance - building slack space into tables
https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/comment_aggregates gets a lot of hammering to set child_count on new replies, it is also probably the 2nd or 3rd largest table in Lemmy's database, votes for post and comments being the largest
Comments 0