Horton

Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5

gzh <gzhcoder@126.com>

View thread View on postgr.es
From: gzh <gzhcoder@126.com>
To: "Adrian Klaver" <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2022-08-18T12:07:47Z
Lists: pgsql-general 


Dear Adrian,


Thanks for your reply.


>Did you run ANALYZE on the 12.5 server after restoring the data to it?
No, I did not run ANALYZE on the 12.5 server after restoring the data.


When I change the select clause like this ( crew_base.crewid → count(*) ), I can retrieve the number of data rows.
Please refer to my previous reply for more information.











At 2022-08-18 12:18:31, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:
>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