On Fri, May 25, 2018 at 9:58 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Greg Clough <greg.clough@ipreo.com> writes:
>> I would like to propose that we expose the "active" value of parameters in pg_settings, instead of "-1". In this
examplebelow, 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
