Because users have a very high search frequency, and considering there are 800,000 topics, I am wondering whether some customized search solution might be necessary.
Depends on your disk performance. If your disk is too slow (IOPS) and your database can’t be cached in memory for most operations, it can quickly become a bottleneck.
Not really, but your specific usage pattern may discover some corner cases. At this scale, specially on the first month it’s a good idea to keep an eye for slow pages and checking if the database needs more resources, vacuum or tuning.