When I first started Pixelfed, I copied Mastodon database schema.
Every post, reply and boost/share all in the same table.
I regret that.
It's now 264.43 GB for pixelfed.social, with a wildly inefficient schema that is my fault, because I thought storing the plaintext version AND the html […]