Sidekiq بطيء + Postmaster يستهلك أكثر من 95% من وحدة المعالجة المركزية (32 نواة) بعد ترقية إصدار PostgreSQL

[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