Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11

Поиск

Список

Период

Сортировка

От	gzh
Тема	Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11
Дата	10 октября 2022 г. 02:32:56
Msg-id	3bb0d13f.1d81.183bfbcf7e4.Coremail.gzhcoder@126.com обсуждение исходный текст
Ответ на	Re: Different execution plan between PostgreSQL 8.4 and 12.11 (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы	Re: Different execution plan between PostgreSQL 8.4 and 12.11
Список	pgsql-general

Дерево обсуждения

Hi Tom,

Thank you for your prompt response.

I've run analyze(not vacuum analyze), but it doesn't seem to work.

Is there any other way to optimize the database?


At 2022-10-10 00:02:09, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>gzh <gzhcoder@126.com> writes:
>> I run following sql in PostgreSQL 8.4 and PostgreSQL 12.11, it returns different execution plan.
>
>Have you done an ANALYZE in the new database?  The rowcount estimates
>seem a lot different, leading me to guess that the newer installation
>doesn't have good statistics yet.
>
>			regards, tom lane

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11