Re: problem with query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sašo Gantar <sasog23(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: problem with query
Date: 2024-05-21 14:18:52
Message-ID: 3901400.1716301132@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?B?U2HFoW8gR2FudGFy?= <sasog23(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-05-21 15:55:03 Re: Restore of a reference database kills the auto analyze processing.
Previous Message HORDER Philip 2024-05-21 13:00:33 RE: Restore of a reference database kills the auto analyze processing.