Re: from_collapse_limit vs. geqo_threshold - Mailing list pgsql-hackers

From Robert Haas
Subject Re: from_collapse_limit vs. geqo_threshold
Date
Msg-id 603c8f070905210638h2e60068fw7efcb96427eb84c5@mail.gmail.com
Whole thread Raw
In response to Re: from_collapse_limit vs. geqo_threshold  (Greg Stark <stark@enterprisedb.com>)
List pgsql-hackers
On Thu, May 21, 2009 at 8:51 AM, Greg Stark <stark@enterprisedb.com> wrote:
> Having just raised the statistics targets I wonder if we should look
> at raising these two parameters too. The experience on the lists are
> that when people run into either of these two limits we recommend
> raising them and we've never seen anyone come back complaining that
> their planning time goes through the roof.
>
> To benchmark this like we did for the statistics target will be tricky
> though. I suppose we can gather candidate queries by trolling the
> lists for recommendations, though we didn't always get schemas to go
> along with the queries.

I think that's a good idea, too, but it's unrelated to the question of
which one should be set to the higher value.

...Robert


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: from_collapse_limit vs. geqo_threshold
Next
From: Heikki Linnakangas
Date:
Subject: Re: psql is broken in 8.4