Re: Same query, same data different plan

From: Kostas Papadopoulos <kostas(at)methodosit(dot)com(dot)cy>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: Daevor The Devoted <dollien(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Same query, same data different plan
Date: 2022-10-10 13:15:56
Message-ID: bcd2392a-eb2c-9a4c-9bdc-765a4045955b@methodosit.com.cy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2022-10-10 13:16:22 Re: Same query, same data different plan
Previous Message Julien Rouhaud 2022-10-10 13:12:17 Re: Same query, same data different plan