Horton

Bug fix in vacuumdb --buffer-usage-limit xxx -Z

Ryoga Yoshida <bt23yoshidar@oss.nttdata.com>

View thread View on postgr.es
From: Ryoga Yoshida <bt23yoshidar@oss.nttdata.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2023-09-21T01:44:49Z
Lists: pgsql-hackers

Attachments

Hi,

When --buffer-usage-limit option is specified, vacuumdb issues VACUUM or 
VACUUM ANALYZE command with BUFFER_USAGE_LIMIT option. Also if 
--buffer-usage-limit and -Z options are specified, vacuumdb should issue 
ANALYZE command with BUFFER_USAGE_LIMIT option. But it does not. That 
is, vacuumdb -Z seems to fail to handle --buffer-usage-limit option. 
This seems a bug.

You can see my patch in the attached file and how it works by adding -e 
option in vacuumdb.

Ryoga Yoshida

Commits

  1. Fix vacuumdb to pass buffer-usage-limit with analyze-only mode