Re: Same query, same data different plan

Поиск
Список
Период
Сортировка
От Kostas Papadopoulos
Тема Re: Same query, same data different plan
Дата
Msg-id bcd2392a-eb2c-9a4c-9bdc-765a4045955b@methodosit.com.cy
обсуждение исходный текст
Ответ на Same query, same data different plan  (Kostas Papadopoulos <kostas@methodosit.com.cy>)
Ответы Re: Same query, same data different plan  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Hi,

Thank you for responding. My question is not about the performance of a specific 
query. As I wrote, that is already solved.

My question is "how can it be that the same query run in two exactly the same 
databases can have different plans."


Kostas Papadopoulos

On 10/10/2022 16:12, Julien Rouhaud wrote:
> On Mon, Oct 10, 2022 at 04:05:42PM +0300, Kostas Papadopoulos wrote:
>> Hi,
>>
>> Yes, I ran ANALYZE in both databases.
> 
> Please look at https://wiki.postgresql.org/wiki/Slow_Query_Questions to provide
> more information.



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

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