17. gpcheckperf :
网络:
gpcheckperf -f hostfile_gpchecknet_ic1 -r N –netperf -d /tmp 磁盘IO
gpcheckperf -f hostfile_gpcheckperf -d /data1 -d /data2 -r d
linux DD 命令:
dd if=/dev/zero of=/vol2/a.test bs=256k count=161000
dd if=/vol2/b.test of=/dev/null bs=256k count=160000
18. gpssh : 同时登陆到多个机器上,进行操作
Gpssh -h sdw1 –h sdw2 -h sdw3
19. gp_toolkit: 管理工具包:
? gp_bloat_diag ? gp_stats_missing
更多详细信息参见GpadminGuide appendix I ;
pg_stat_last_operation:Shows the last time certain database operations were performed
on a database object, for example, the last time a table was vacuumed