Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5 - Mailing list pgsql-general

From Torsten Krah
Subject Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date
Msg-id CAN2Hv7Byw20GYNxY-h+JFdLGvvAUszLNOZTnfQZjn5pvJfOpCg@mail.gmail.com
Whole thread Raw
In response to Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5  (gzh <gzhcoder@126.com>)
List pgsql-general
Tree view
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.
...


pgsql-general by date:

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