Setting maintenance_work_mem does not apply to server

[orlovmyk]

According to CNPG guide, I've tried to set maintenance_work_mem as well as other params in my cluster:

    postgresql:
      parameters:
        shared_buffers: "2GB"
        effective_cache_size: "6GB"
        work_mem: "64MB"
        random_page_cost: "4" # default
        maintenance_work_mem: "64MB"

Other params works fine, but maintenance_work_mem remains default. Also I've check guide it's not fixed param: https://cloudnative-pg.io/documentation/1.16/postgresql_conf/#fixed-parameters

[mrlhansen]

I am seeing the same problem, but I think the issue is the exported metrics value. In my case I was setting the value to 256MB and it reports 256KB, so it hinted at as problem with units, since you see the same (64MB vs. 64KB). I was looking at the configuration in Postgres itself and I see that maintenance_work_mem has the value of 262144 with units of kB - this is indeed 256MB.

[dosubot[bot]]

Hi, @orlovmyk. I'm Dosu, and I'm helping the charts team manage their backlog. I'm marking this issue as stale.

Issue Summary

• The maintenance_work_mem parameter was not applied correctly in the PostgreSQL server configuration.
• User mrlhansen suggested the issue might be due to a units of measurement discrepancy between MB and KB.
• The actual PostgreSQL configuration reflects the correct value in kilobytes, indicating a metrics reporting issue.

Next Steps

• Please confirm if this issue is still relevant to the latest version of the charts repository. If so, you can keep the discussion open by commenting on the issue.
• Otherwise, this issue will be automatically closed in 7 days.

Thank you for your understanding and contribution!