Re: Different execution plan between PostgreSQL 8.2 and 12.5

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: gzh <gzhcoder(at)126(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date: 2022-08-18 04:18:31
Message-ID: ac341640-345f-2848-bcd9-ac814787ff02@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-08-18 05:53:15 Re: Setting up streaming replication on large database (20+ TB) for the first time
Previous Message David Rowley 2022-08-18 03:38:58 Re: Different execution plan between PostgreSQL 8.2 and 12.5