Re: BUG #16940: ERROR: unrecognized parameter

Le mar. 23 mars 2021 à 15:38, Guillaume Lelarge <guillaume(at)lelarge(dot)info> a
écrit :

> Hi,
>
> Le mar. 23 mars 2021 à 14:31, PG Bug reporting form <
> noreply(at)postgresql(dot)org> a écrit :
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16940
>> Logged by: Zhu Ethan
>> Email address: crimezjp(at)foxmail(dot)com
>> PostgreSQL version: 13.2
>> Operating system: Ubuntu 20.04
>> Description:
>>
>> postgres=# CREATE TEMP TABLE IF NOT EXISTS t0(c0 REAL PRIMARY KEY DEFAULT
>> (0.7718745), c1 boolean , c2 FLOAT DEFAULT (0.4103656432464894))
>> PARTITION
>> BY RANGE((t0.c0)) WITH (autovacuum_vacuum_cost_delay=84,
>> autovacuum_freeze_table_age=797746365, autovacuum_enabled=0,
>> parallel_workers=736, autovacuum_vacuum_cost_limit=1031, fillfactor=89,
>> autovacuum_freeze_min_age=296312345,
>> autovacuum_analyze_threshold=542044648,
>> autovacuum_freeze_max_age=1616982866) ON COMMIT DROP ;
>> ERROR: 22023: unrecognized parameter "autovacuum_vacuum_cost_delay"
>> LOCATION: parseRelOptionsInternal, reloptions.c:1445
>>
>> postgres=# CREATE TEMPORARY TABLE IF NOT EXISTS t0(c0 boolean DEFAULT
>> ((to_hex('0.9439359616884709')) IN (family('255.150.15.43')))) PARTITION
>> BY
>> HASH((t0.c0)oidvector_ops) WITH (autovacuum_freeze_min_age=404730583,
>> fillfactor=91, autovacuum_vacuum_scale_factor=1.0E-5,
>> autovacuum_vacuum_cost_delay=64, autovacuum_freeze_max_age=434090753,
>> autovacuum_analyze_threshold=1645614243, parallel_workers=74,
>> autovacuum_enabled=1, autovacuum_analyze_scale_factor=0.2) ON COMMIT DROP
>> ;
>> ERROR: 22023: unrecognized parameter "autovacuum_freeze_min_age"
>> LOCATION: parseRelOptionsInternal, reloptions.c:1445
>>
>>
> Not a bug. autovacuum_vacuum_cost_delay and autovacuum_freeze_min_age are
> not table storage parameters.
>
>
And actually, they are. My bad.

--
Guillaume.