Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date
Msg-id ac341640-345f-2848-bcd9-ac814787ff02@aklaver.com
Whole thread Raw
In response to Different execution plan between PostgreSQL 8.2 and 12.5  (gzh <gzhcoder@126.com>)
Responses Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
List pgsql-general
Tree view 
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@aklaver.com

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Next
From: Ron
Date:
Subject: Re: Setting up streaming replication on large database (20+ TB) for the first time