Horton

Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5

Torsten Krah <krah.tm@gmail.com>

View thread View on postgr.es
From: Torsten Krah <krah.tm@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2022-08-18T12:22:09Z
Lists: pgsql-general 
But you should do that according to the documentation:

...
After restoring a backup, it is wise to run ANALYZE on each database so the
query optimizer has useful statistics.
...