Re: fix stats_fetch_consistency value in postgresql.conf.sample

From: Andres Freund <andres(at)anarazel(dot)de>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: pryzby(at)telsasoft(dot)com, michael(at)paquier(dot)xyz, nathandbossart(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: fix stats_fetch_consistency value in postgresql.conf.sample
Date: 2022-05-28 20:22:45
Message-ID: 20220528202245.lrjn3v2m5shzgbsq@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2022-05-26 16:27:53 +0900, Kyotaro Horiguchi wrote:
> It could be in SQL, but *I* prefer to use perl for this, since it
> allows me to write a bit complex things (than simple string
> comparison) simpler.

I wonder if we shouldn't just expose a C function to do this, rather than
having a separate implementation in a tap test.

> +# parameter names that cannot get consistency check performed
> +my @ignored_parameters =

I think most of these we could ignore by relying on source <> 'override'
instead of listing them?

> +# parameter names that requires case-insensitive check
> +my @case_insensitive_params =
> + ('ssl_ciphers',
> + 'log_filename',
> + 'event_source',
> + 'log_timezone',
> + 'timezone',
> + 'lc_monetary',
> + 'lc_numeric',
> + 'lc_time');

Why do these differ by case?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2022-05-28 20:50:59 Re: Ignoring BRIN for HOT udpates seems broken
Previous Message Andres Freund 2022-05-28 20:14:09 Re: fix stats_fetch_consistency value in postgresql.conf.sample