Database disk usage

Troubleshooting
1

In the few weeks since I upgraded from 5.33 to 5.38 my PostgreSQL database disk usage has more than doubled. Following How do you find the disk size of a Postgres / PostgreSQL table and its indexes - Stack Overflow

  • threadmemberships is biggest table & 5x bigger than posts which is the next biggest
  • it appears my indexes are bigger than my tables for posts & threadmemberships

Is this normal? Should I expect the new Norm to be much faster disk usage increases?

2

A response from a dev: This seems to be expected. The reason is the addition of collapsed reply threads, which require a lot of additional administration to keep track of who’s participating in which thread (thread membership).