Re: Specifying the unit in storage parameter - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Specifying the unit in storage parameter
Date
Msg-id CAB7nPqSgWYr2xNE0uGf=L1fBfyp5zrfu+VuCooUDeHrtgqEpAw@mail.gmail.com
Whole thread Raw
In response to Specifying the unit in storage parameter  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Specifying the unit in storage parameter
List pgsql-hackers
On Fri, Aug 8, 2014 at 12:32 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> This is not user-friendly. I'd like to propose the attached patch which
> introduces the infrastructure which allows us to specify the unit when
> setting INTEGER storage parameter like autovacuum_vacuum_cost_delay.
> Comment? Review?
This patch makes autovacuum_vacuum_cost_delay more consistent with
what is at server level. So +1.

Looking at the patch, the parameter "fillfactor" in the category
RELOPT_KIND_HEAP (the first element in intRelOpts of reloptions.c) is
not updated with the new field. It is only a one-line change.
@@ -97,7 +97,7 @@ static relopt_int intRelOpts[] =                       "Packs table pages only to this percentage",
                   RELOPT_KIND_HEAP               },
 
-               HEAP_DEFAULT_FILLFACTOR, HEAP_MIN_FILLFACTOR, 100
+               HEAP_DEFAULT_FILLFACTOR, HEAP_MIN_FILLFACTOR, 100, 0       },

Except that, I tested as well the patch and it works as expected. The
documentation, as well as the regression tests remain untouched, but I
guess that this is fine (not seeing similar tests in regressions, and
documentation does not specify the unit for a given parameter).

Regards,
-- 
Michael



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: pg_xlogdump --stats
Next
From: Andrew Gierth
Date:
Subject: Re: WIP Patch for GROUPING SETS phase 1