Tanzu Greenplum functions running slowly

Products

• VMware Tanzu Greenplum

Issue/Introduction

You are experiencing the following symptoms in Tanzu Greenplum:

• Many functions that are running slowly.
• Temporary tables are created in the functions and then later used in the functions.
• Using "SELECT gp_workfile_usage_per_segment;" shows many spill files being created.

Environment

Product Version: 5.25

Resolution

Check the setting for "gp_autostat_mode_in_functions":

gpconfig -s gp_autostats_mode_in_functions

By default it is set to "none". Change the setting to "on_no_stats":

gpconfig -c gp_autostats_mode_in_functions -v on_no_stats

Reload the configuration:

gpstop -u

Verify the setting has changed:

gpconfig -s gp_autostats_mode_in_functions

For more information on the GUC, refer to the following resources:

• gp_autostats_mode_in_functions
• gp_autostats_mode