Thank you for your feedback about non-working sort by posts count under tags – we will fix it in the nearest release.
Regarding the overall performance – to be honest – Publii was designed for smaller websites and we did not focus on such cases when user has few thousands of posts. Also due nature of the posts listing – it is not easy to implement some pagination etc. without big rewrite of the app views :/
Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!