Re: [HACKERS] GUC for cleanup indexes threshold.
Alexander Korotkov <a.korotkov@postgrespro.ru>
From: Alexander Korotkov <a.korotkov@postgrespro.ru>
To: Sawada Masahiko <sawada.mshk@gmail.com>
Cc: Darafei Praliaskouski <me@komzpa.net>,
Simon Riggs <simon@2ndquadrant.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>,
Yura Sokolov <y.sokolov@postgrespro.ru>, Peter Geoghegan <pg@bowt.ie>, Andres Freund <andres@anarazel.de>,
Robert Haas <robertmhaas@gmail.com>, David Steele <david@pgmasters.net>, Amit Kapila <amit.kapila16@gmail.com>, "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>, pgsql-hackers <pgsql-hackers@postgresql.org>,
Kuntal Ghosh <kuntalghosh.2007@gmail.com>, pgsql-hackers-owner@postgresql.org
Date: 2018-06-20T09:00:31Z
Lists: pgsql-hackers
On Wed, Jun 20, 2018 at 8:32 AM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > On Wed, Jun 20, 2018 at 1:00 AM, Alexander Korotkov > > Ok. I've rephrased comment a bit. Also, you created "index vacuum" > > subsection in the "resource usage" section. I think it's not > > appropriate for this option to be in "resource usage". Ideally it > > should be grouped with other vacuum options, but we don't have single > > section for that. "Autovacuum" section is also not appropriate, > > because this guc works not only for autovacuum. So, most semantically > > close options, which affects vacuum in general, are > > vacuum_freeze_min_age, vacuum_freeze_table_age, > > vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age, > > which are located in "client connection defaults" section. So, I > > decided to move this GUC into this section. I also change the section > > in GUC definition (guc.c) from AUTOVACUUM to CLIENT_CONN_STATEMENT. > > Agreed. So should we move it to 19.11 Client Connection Defaults in > doc as well? And I think it's better if this option places next to > other vacuum options for finding easier. Attached patch changes them > so. Please review it. Right, thank you. Looks good for me. I'm going to commit this if no objections. ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Commits
-
Fix upper limit for vacuum_cleanup_index_scale_factor
- 4d54543efa5e 11.0 landed
-
Increase upper limit for vacuum_cleanup_index_scale_factor
- 6ca33a885bf8 11.0 landed
-
Fixes for vacuum_cleanup_index_scale_factor GUC option
- 9a994e37e08d 11.0 landed
-
Skip full index scan during cleanup of B-tree indexes when possible
- 857f9c36cda5 11.0 landed