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

Started by Tatsuo Ishiialmost 10 years ago2 messages
#1Tatsuo Ishii
ishii@postgresql.org

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Michael Paquier
michael.paquier@gmail.com
In reply to: Tatsuo Ishii (#1)
Re: Why vacuum_freeze_table_age etc. doc in "Statement Behavior" section?

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers