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

From: Torsten Krah <krah(dot)tm(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date: 2022-08-18 12:22:09
Message-ID: CAN2Hv7Byw20GYNxY-h+JFdLGvvAUszLNOZTnfQZjn5pvJfOpCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.
...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan N. Ivanov 2022-08-18 12:35:10 Re: [(catch-ext)] Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time
Previous Message gzh 2022-08-18 12:07:47 Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5