On Fri, May 25, 2018 at 9:58 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Greg Clough <greg.clo...@ipreo.com> writes: >> I would like to propose that we expose the "active" value of parameters in >> pg_settings, instead of "-1". In this example below, when it's set to "-1" >> I need to know that autovacuum_work_mem is related to the setting of >> maintenance_work_mem, so that I can determine that the actual setting is >> 64MB: > > If we did that, how would you tell the difference between "-1" and a hard > setting of 64MB? >
He's proposing an extra column to show the actual value used, so distinguishing them should be a problem. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
