Langsamer Sidekiq + Postmaster mit 95%+ CPU (32 Kerne) nach Postgresql-Version-Upgrade

[markersocial]

Maybe try running:

VACUUM FULL VERBOSE;

and (assuming your db name is ‘discourse’ which is default):

REINDEX DATABASE discourse;

This might be better than normal reindex, but I haven’t tested it: PostgreSQL 12 update