On 10/03/2014 09:42 PM, Bruce Momjian wrote:
On Fri, Oct 3, 2014 at 03:30:35PM -0300, Arthur Silva wrote:> Every GUC add complexity to the system because people have to understand > it to know if they should tune it. No GUC is zero-cost.Please see my blog post about the cost of adding GUCs: http://momjian.us/main/blogs/pgblog/2009.html#January_10_2009 That's true Bruce (nice post, it was a good reading). But how can we ignore 25%+ improvements (from 8 to 24)? At very least we should delivery some pretty good defaults.Well, checkpoint_segments was a similar case where we couldn't give good tuning advice so we went with a server log file warning if it needed to be increased --- this might be a similar case.
I have no idea how to decide at runtime whether it should be increased or not. If that was feasible, we probably could make it tune itself on the fly - it's not like checkpoint_segments where you need more disk space if you increase it.
I stand by my decision to make it a #define, at least until someone voices their objection in the form of a documentation patch.
- Heikki -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
