Search Postgresql Archives
Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5
From
: Torsten Krah <krah.tm@xxxxxxxxx>
Date
: Thu, 18 Aug 2022 14:22:09 +0200
In-reply-to
: <
19dcd2b3.679d.182b0da37c2.Coremail.gzhcoder@126.com
>
References
: <
6614e60.204d.182aee5aff0.Coremail.gzhcoder@126.com
> <
ac341640-345f-2848-bcd9-ac814787ff02@aklaver.com
> <
19dcd2b3.679d.182b0da37c2.Coremail.gzhcoder@126.com
>
Reply-to
: krah.tm@xxxxxxxxx
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.
...
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Different execution plan between PostgreSQL 8.2 and 12.5
From:
gzh
Re: Different execution plan between PostgreSQL 8.2 and 12.5
From:
Adrian Klaver
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
From:
gzh
Prev by Date:
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Next by Date:
Re: [(catch-ext)] Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time
Previous by thread:
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Next by thread:
Unable to Create or Drop Index Concurrently
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
