分析分区表的时间与分析具有相同数据的非分区表的时间相似,因为ANALYZE ROOTPARTITION不收集有关叶分区的统计信息(仅对数据进行采样)。 Greenplum数据库的服务器配置参数optimizer_analyze_root_partition,它影响何时在分区表的根分区上收集统计信息。如果参数是on(默认),则在运行ANALYZE时,不需要ROOTPARTITION关键字来收集...
Database administrators can connect directly to the gpperfmon database using any VMware Greenplum-compatible client program (such aspsql). For example: $ psql -d gpperfmon -h coordinator_host -p 5432 -U gpadmin Backing Up and Restoring the gpperfmon Database The history tables of the gpperfmon ...
2 changes: 1 addition & 1 deletion 2 gpAux/gpperfmon/src/gpmon/gpmondb.c Original file line numberDiff line numberDiff line change @@ -1509,7 +1509,7 @@ apr_status_t gpdb_check_partitions(mmon_options_t *opt) { // health is not a full table and needs to be added to the lis...
configuration made by gpperfmon_install script. Ident authentication is used for gpmon role, so actual password is not stored in .pgpass file. As a compatibility option gpmon role may use md5 password authentication as usual. In gpperfmon_install script --password option no longer required for -...