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

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com