Обсуждение: Why vacuum_freeze_table_age etc. doc in "Statement Behavior" section?

Поиск
Список
Период
Сортировка

Why vacuum_freeze_table_age etc. doc in "Statement Behavior" section?

От
Tatsuo Ishii
Дата:
The explanations for vacuum_freeze_table_age etc. are in the section
"Statement Behavior", which is a subsection of "Client Connection
Defaults". To me vacuum_freeze_table_age etc. are totally unrelated
to "Client Connection Defaults".

I think "Resource Consumption" section is more appropriate for their
place. There's already a section "Cost-based Vacuum Delay". Maybe we
can add a new section for below under "Resource Consumption" something
like "Managing Vacuum Freeze".

vacuum_freeze_min_age
vacuum_freeze_table_age
vacuum_multixact_freeze_min_age
vacuum_multixact_freeze_table_age

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



Re: Why vacuum_freeze_table_age etc. doc in "Statement Behavior" section?

От
Michael Paquier
Дата:
On Wed, Feb 24, 2016 at 2:00 PM, Tatsuo Ishii <ishii@postgresql.org> wrote:
> The explanations for vacuum_freeze_table_age etc. are in the section
> "Statement Behavior", which is a subsection of "Client Connection
> Defaults". To me vacuum_freeze_table_age etc. are totally unrelated
> to "Client Connection Defaults".
>
> I think "Resource Consumption" section is more appropriate for their
> place. There's already a section "Cost-based Vacuum Delay". Maybe we
> can add a new section for below under "Resource Consumption" something
> like "Managing Vacuum Freeze".
>
> vacuum_freeze_min_age
> vacuum_freeze_table_age
> vacuum_multixact_freeze_min_age
> vacuum_multixact_freeze_table_age

Those are parameters related controlling the way the query VACUUM
behaves, that's why they are placed where they are now, but so do the
cost-based parameters. So +1 for a new section under Resource
Consumption".
-- 
Michael