gpcheckcat
1 概述
GP 提供了 gpcheckcat 用于在集群内检查系统表。
| 检查项 | 描述 | Utility 模式 | 复合查询 | 错误等级 |
|---|---|---|---|---|
| pg_class | Check pg_class entry that does not have any correspond pg_attribute entry | Y | N | NOREPAIR |
| namespace | Check for schemas with a missing schema definition | Y | N | NOREPAIR |
| unique_index_violation | Check for violated unique indexes | N | Y | NOREPAIR |
| duplicate | Check for duplicate entries | N | Y | |
| missing_extraneous | Cross consistency check for missing or extraneous entries | N | Y | |
| inconsistent | Cross consistency check for coordinator segment inconsistency | N | ||
| foreign_key | Check foreign keys | N |
Note: