Re: problem with query

[Sašo Gantar <sasog23@xxxxxxxxx>]

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šo Gantar <sasog23@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:

=?UTF-8?B?U2HFoW8gR2FudGFy?= <sasog23@xxxxxxxxx> 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