> Have you run an analyze on all your tables after the upgrade to 10? The
> estimates are way off.
Thank you. I embarrassingly missed that step. That fixed the problem. In the
future, if estimates are way off… I’ll run analyze.
Have you run an analyze on all your tables after the upgrade to 10? The
estimates are way off.
Greetings,
I have several similar queries that are all suffering from a dramatic slow down
after upgrading a RDS instance from 9.3 to 10.3. The query time goes from 28
milliseconds to over 70 seconds I could use some help trying to figure out the
problem. This is one of the queries:
SELECT
