Postgres Pro
Downloads
Home   >   mailing lists

Re: Same query, same data different plan - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Same query, same data different plan
Date
Msg-id CAFj8pRDrXx3Vn4tosO=QO_LgpRu9MnrnPsz8dfDJpL2z51StiA@mail.gmail.com
Whole thread Raw
In response to Re: Same query, same data different plan  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
Tree view


po 10. 10. 2022 v 15:12 odesílatel Julien Rouhaud <rjuju123@gmail.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.


pgsql-general by date:

Previous
From: Kostas Papadopoulos
Date:
Subject: Re: Same query, same data different plan
Next
From: Kostas Papadopoulos
Date:
Subject: Re: Same query, same data different plan