Re: worker_spi example BGW code GUC tweak - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: worker_spi example BGW code GUC tweak
Date
Msg-id b4e677b0-fcc7-6f62-06ad-a1d914949f50@anastigmatix.net
Whole thread Raw
In response to Re: worker_spi example BGW code GUC tweak  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: worker_spi example BGW code GUC tweak
List pgsql-hackers
On 12/17/2017 07:32 PM, Robert Haas wrote:

> Making it use GUC_UNIT_S seems like a good idea to me, but removing
> the mention of seconds from the description doesn't seem like a good
> idea to me.

I took for my model a quick survey of existing GUCs that use
GUC_UNIT_(MS|S|MIN) - most of which do not restate the time unit
in the text description. (It's not a shut-out; some do, but only
a handful.)

I think that makes sense, because once the GUC_UNIT_foo is
specified, you get output like:

select current_setting('worker_spi.naptime');
 current_setting
-----------------
 10s

and, if you set it for, say, 120000ms or 180min, it will be
displayed as 2min or 3h, etc., making 'seconds' in the text
description a little redundant in the best case—when the
current value is most naturally shown with s—and a little
goofy in the other cases, where the value would be displayed
with min, h, or d, and reading the value combined with the text
description makes the snarky little voice in your head go
"nap for 3 hours seconds??".

-Chap


pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: es_query_dsa is broken
Next
From: Robert Haas
Date:
Subject: Re: genomic locus