MIME-Version: 1.0
References: <CAGB0_6600w5C=hvhgfMWCqO9BCwCg+3s0PxXuoQv48NLqTp6dA@mail.gmail.com>
 <CAApHDvq=sj+vVQ6HKOdNLeWbQnHErg5QPSz26s0a90PtY1NLdw@mail.gmail.com>
 <CAGB0_67gRyJkCycv6vJA_8fFtNUu7H-f-nsKastZTe93gobBHA@mail.gmail.com>
 <db92077786681509d1901262b2312d26be6a99eb.camel@cybertec.at>
 <CAGB0_67+MbsqatNyone7cx5ziuKy_DfV=MLTcc6T0BfoS3Qyrw@mail.gmail.com>
 <3901400.1716301132@sss.pgh.pa.us> <CAGB0_67P1JNuVXAijwXtET9YTpqWO=Uii=oeMb-KVaKXQCp=JQ@mail.gmail.com>
In-Reply-To: <CAGB0_67P1JNuVXAijwXtET9YTpqWO=Uii=oeMb-KVaKXQCp=JQ@mail.gmail.com>
From: =?UTF-8?B?U2HFoW8gR2FudGFy?= <sasog23@gmail.com>
Date: Mon, 27 May 2024 13:39:54 +0200
Message-ID: <CAGB0_65WW2GRF9qRx112a+jVeWLPSw+tyGKeuu_eNp8x+e7AbA@mail.gmail.com>
Subject: Re: problem with query
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, David Rowley <dgrowleyml@gmail.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000008588d606196dfa09"
Archived-At: <https://www.postgresql.org/message-id/CAGB0_65WW2GRF9qRx112a%2BjVeWLPSw%2BtyGKeuu_eNp8x%2Be7AbA%40mail.gmail.com>
Precedence: bulk

--0000000000008588d606196dfa09
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

upgrade to "PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on
x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit"
solved the problem

regards,
s

On Wed, 22 May 2024 at 06:04, Sa=C5=A1o Gantar <sasog23@gmail.com> wrote:

> ANALYZE pg_class; doesn't help
> also, query is from "Hasura", so I don't have much room to maneuver
>
> On Tue, 21 May 2024 at 16:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> =3D?UTF-8?B?U2HFoW8gR2FudGFy?=3D <sasog23@gmail.com> writes:
>> > thanks for the info, but is there any solution, given that it's system
>> > tables?
>>
>> Given the complexity of the query, I wonder if you're running into
>> problems with join_collapse_limit/from_collapse_limit preventing
>> the planner from considering all options.
>>
>> Also, as David already mentioned, ANALYZE on pg_class might help.
>>
>>                         regards, tom lane
>>
>

--0000000000008588d606196dfa09
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">upgrade to &quot;PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1)=
 on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit&=
quot;<div>solved the problem</div><div><br></div><div>regards,</div><div>s<=
/div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_a=
ttr">On Wed, 22 May 2024 at 06:04, Sa=C5=A1o Gantar &lt;<a href=3D"mailto:s=
asog23@gmail.com">sasog23@gmail.com</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">ANALYZE pg_class; doesn=
&#39;t help<br><div>also, query is from &quot;Hasura&quot;, so I don&#39;t =
have much room to maneuver</div></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Tue, 21 May 2024 at 16:18, Tom Lane &lt;=
<a href=3D"mailto:tgl@sss.pgh.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=3D=
?UTF-8?B?U2HFoW8gR2FudGFy?=3D &lt;<a href=3D"mailto:sasog23@gmail.com" targ=
et=3D"_blank">sasog23@gmail.com</a>&gt; writes:<br>
&gt; thanks for the info, but is there any solution, given that it&#39;s sy=
stem<br>
&gt; tables?<br>
<br>
Given the complexity of the query, I wonder if you&#39;re running into<br>
problems with join_collapse_limit/from_collapse_limit preventing<br>
the planner from considering all options.<br>
<br>
Also, as David already mentioned, ANALYZE on pg_class might help.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>
</blockquote></div>

--0000000000008588d606196dfa09--