Max sane value for join_collapse_limit?

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Max sane value for join_collapse_limit?
Date: 2022-06-03 08:19:12
Message-ID: VisenaEmail.12.47d4bf3bfc1463af.18128a3ef80@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I have set join_collapse_limit = 12 in production, but I'm thinking about
raising it to 16.

On modern HW is there a “sane maximum” for this value?

I can easily spare 10ms for extra planning per query on our workload, is 16
too high?

Thanks.

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jian he 2022-06-03 10:38:50 Re: GIN theory
Previous Message Merlin Moncure 2022-06-02 23:00:41 Re: [EXT] Re: Accessing composite type elements