Postgres Pro
Downloads
Home   >   mailing lists

Max sane value for join_collapse_limit? - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Max sane value for join_collapse_limit?
Date
Msg-id VisenaEmail.12.47d4bf3bfc1463af.18128a3ef80@tc7-visena
Whole thread Raw
Responses Re: Max sane value for join_collapse_limit?  (Philip Semanchuk <philip@americanefficient.com>)
List pgsql-general
Tree view

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
Attachment

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [EXT] Re: Accessing composite type elements
Next
From: jian he
Date:
Subject: Re: GIN theory