Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
| От | gzh |
|---|---|
| Тема | Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 |
| Дата | |
| Msg-id | 19dcd2b3.679d.182b0da37c2.Coremail.gzhcoder@126.com обсуждение исходный текст |
| Ответ на | Re: Different execution plan between PostgreSQL 8.2 and 12.5 (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5
|
| Список | 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
В списке pgsql-general по дате отправления: