Horton

Re: Different execution plan between PostgreSQL 8.2 and 12.5

Adrian Klaver <adrian.klaver@aklaver.com>

View thread View on postgr.es
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: gzh <gzhcoder@126.com>, pgsql-general@lists.postgresql.org
Date: 2022-08-18T04:18:31Z
Lists: pgsql-general 
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