Re: vacuum_defer_cleanup_age

On 11/06/10 05:36, Fujii Masao wrote:
> vacuum_defer_cleanup_age is categorized as "Statement Behavior"
> parameter in the document. On the other hand, it's categorized
> as "Hot Standby" one in postgresql.conf. Why do we need to do so?

Yeah, there's clearly a mismatch. I think "Hot Standby" is the right
place, altough you could argue that it should be together with
vacuum_freeze_min_age and vacuum_freeze_table_age too.

We seem to be missing an entry for "Write-Ahead Log / Hot Standby" in
the config_group_names list in guc.c. hot_standby GUC marked to beling
in WAL_SETTINGS in guc.c.

What's the policy with that, should all the sections in the sample
config file and docs have a corresponding enum in config_group_names? I
guess they should, but many of them seem to be missing. There's no
separate entry in config_group_names for "Write-Ahead Log / Archiving",
"Resource Usage / Cost-Based Vacuum Delay" and "Resource Usage /
Asynchronous Behavior" either, for example.

Should I add entries in the enum for all the missing ones?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com