Filling the forum now, everything is working fine) But as it fills one problem will arise.
I have about 30 categories, and about 1500 subcategories. I notice that the more subcategories, the longer the main page takes to form (about 5 seconds at the moment). Other than that, it works pretty fast. My configuration is 4 cores, 6 GB RAM, SSD. The shared buffers are set to 1.5 GB.
Maybe there is some ready-made recommendations how to increase loading speed of the main page? I don’t think the problem is in the postgresql sampling, I think it is in the rendering of the main page.
I think every forum will have a different set-up and style, and different organisational needs, so there’s not going to be a precise number, but 1500 subcategories is certainly at the larger end. How many topics do you have in each subcategory? (and could they be better served using tags)