Huge performance degradation after upgrade to Postgres 16

Question

Heroku updated my Postgres instance from version 13 to 16 tonight.

After this update we have huge performance issues. The simplest queries take a few seconds to execute.

Regardless of whether I do it through an application or manually through an IDE/DBeaver.

Has anyone had a similar problem?

Answer 1

I fixed this problem. I must REINDEX all schemas.