On 1/31/18 14:45, Robert Haas wrote: > We could do that, but I'd be more inclined just to let JIT be > magically enabled. In general, if a user could do 'yum install ip4r' > (for example) and have that Just Work without any further database > configuration,
One way to do that would be to have a system-wide configuration file like /usr/local/pgsql/etc/postgresql/postgresql.conf, which in turn includes /usr/local/pgsql/etc/postgresql/postgreql.conf.d/*, and have the add-on package install its configuration file with the setting jit = on there. Then again, if we want to make it simpler, just link the whole thing in and turn it on by default and be done with it. Presumably, there will be planner-level knobs to model the jit startup time, and if you don't like it, you can set that very high to disable it. So we don't necessarily need a separate turn-it-off-it's-broken setting. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services