Re: Same query, same data different plan

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: Kostas Papadopoulos <kostas(at)methodosit(dot)com(dot)cy>, 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:16:22
Message-ID: CAFj8pRDrXx3Vn4tosO=QO_LgpRu9MnrnPsz8dfDJpL2z51StiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

po 10. 10. 2022 v 15:12 odesílatel Julien Rouhaud <rjuju123(at)gmail(dot)com>
napsal:

> On Mon, Oct 10, 2022 at 04:05:42PM +0300, Kostas Papadopoulos wrote:
> > Hi,
> >
> > Yes, I ran ANALYZE in both databases.
>

This can be a common case. Check your configuration: work_mem,
shared_buffers, effective_cache_size, random_page_cost, seq_page_cost, ...

> 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 Kostas Papadopoulos 2022-10-10 13:23:43 Re: Same query, same data different plan
Previous Message Kostas Papadopoulos 2022-10-10 13:15:56 Re: Same query, same data different plan