Search Postgresql Archives

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: Different execution plan between PostgreSQL 8.2 and 12.5
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Wed, 17 Aug 2022 21:18:31 -0700
Feedback-id: i76984098:Fastmail
In-reply-to: <6614e60.204d.182aee5aff0.Coremail.gzhcoder@126.com>
References: <6614e60.204d.182aee5aff0.Coremail.gzhcoder@126.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.12.0

On 8/17/22 20:01, gzh wrote:

Hi,


I have had a Perl Website working for 7 years and have had no problems

until a few weeks ago I replaced my database server with a newer one.


Did you run ANALYZE on the 12.5 server after restoring the data to it?

gzh



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
  - From: gzh

References:
- Different execution plan between PostgreSQL 8.2 and 12.5
  - From: gzh

Prev by Date: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Next by Date: Re: Setting up streaming replication on large database (20+ TB) for the first time
Previous by thread: Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Next by thread: Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
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]

Powered by Linux