Re: Same query, same data different plan

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>, Kostas Papadopoulos <kostas(at)methodosit(dot)com(dot)cy>
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 14:26:02
Message-ID: db707ea2-3de7-05b9-b376-0f4634fb9866@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/10/22 06: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.
>

Without the information, as detailed at above link, an answer to this
question will be nothing more then guesses.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-10-10 14:53:43 Re: Same query, same data different plan
Previous Message Kostas Papadopoulos 2022-10-10 14:04:52 Re: Same query, same data different plan