Re: Same query, same data different plan

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.