Skip to content

ybd_analyze_after_loads (boolean)

Analyze operations are used to keep statistics up to date, as described in Auto-Analyzing Tables.

If your workload consists of a large number of continuous loads using ybload or the LOAD TABLE command, you may need to disable the subsequent ANALYZE operations that take place after each operation by setting this configuration parameter. This parameter defaults to ON.

For example, to set the parameter for a role performing bulk loads:

sql
create role ybload_user;
alter role ybload_user set ybd_analyze_after_loads to off;

After changing this parameter, you have to reload the system configuration (or restart the database) before the new behavior takes effect.

See also ybd_analyze_after_writes.