Re: Same query, same data different plan

Поиск
Список
Период
Сортировка
От Daevor The Devoted
Тема Re: Same query, same data different plan
Дата
Msg-id CAAZnbVoCXD0d6AKDjoEUD2NXzH1KugMUGy69Whs0_tfH-LPXcw@mail.gmail.com
обсуждение исходный текст
Ответ на Same query, same data different plan  (Kostas Papadopoulos <kostas@methodosit.com.cy>)
Ответы Re: Same query, same data different plan  (Kostas Papadopoulos <kostas@methodosit.com.cy>)
Список pgsql-general
Hi

Is the table stats up to date on both?


Best regards,
Na-iem Dollie

On Mon, Oct 10, 2022 at 2:56 PM Kostas Papadopoulos <kostas@methodosit.com.cy> wrote:

I have two identical databases running in the same instance of Postgresql. Ran
analyze on both. Running the same query I'm getting different plans, one x10 slower.
Although I have solved my problem by re-writing the query, I want to understand why
this is happening. If the configuration, Postgresql version, schema and data are the
same, what other factors is the planner considering?

--

Kostas Papadopoulos
KE MethodosIT



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

Предыдущее
От: Kostas Papadopoulos
Дата:
Сообщение: Same query, same data different plan
Следующее
От: Kostas Papadopoulos
Дата:
Сообщение: Re: Same query, same data different plan