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.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-05-21 13:38:12|
|Subject: Re: from_collapse_limit vs. geqo_threshold|
|Previous:||From: Zdenek Kotala||Date: 2009-05-21 12:47:44|
|Subject: psql is broken in 8.4|