# 初始化pgbench测试数据
$ pgbench -i -s 100 fgedudb

# 输出日志：
dropping old tables…
NOTICE: table “pgbench_accounts” does not exist, skipping
NOTICE: table “pgbench_branches” does not exist, skipping
NOTICE: table “pgbench_history” does not exist, skipping
NOTICE: table “pgbench_tellers” does not exist, skipping
creating tables…
generating data…
100000 of 10000000 tuples (1%) done
…
10000000 of 10000000 tuples (100%) done
creating primary keys…
done.

# 运行基准测试
$ pgbench -c 10 -j 4 -T 300 fgedudb

# 输出日志：
pgbench (9.4.26)
starting vacuum…end.
transaction type: TPC-B (sort of)
scaling factor: 100
query mode: simple
number of clients: 10
number of threads: 4
duration: 300 s
number of transactions actually processed: 150000
latency average: 20.000 ms
tps = 500.000000 (including connections establishing)
tps = 500.500000 (excluding connections establishing)

学习交流加群风哥QQ113257174

# 创建并发测试脚本
$ cat > /GreenPlum/scripts/concurrent_test.sh << 'EOF' #!/bin/bash # concurrent_test.sh # from:www.itpux.com.qq113257174.wx:itpux-com # web: http://www.fgedu.net.cn CONCURRENT=50 ITERATIONS=100 for i in $(seq 1 $CONCURRENT); do ( for j in $(seq 1 $ITERATIONS); do psql -d fgedudb -c "SELECT count(*) FROM fgedu.fgedu_sales WHERE sale_date = CURRENT_DATE;" > /dev/null 2>&1
done
) &
done

wait
echo “并发测试完成”
EOF

# 执行并发测试
$ chmod +x /GreenPlum/scripts/concurrent_test.sh
$ time /GreenPlum/scripts/concurrent_test.sh

# 输出日志：
并发测试完成

real 5m30.123s
user 2m15.456s
sys 1m20.789s

# 监控并发连接
$ psql -d fgedudb -c “SELECT count(*) FROM pg_stat_activity;”

# 输出日志：
count
——-
52
(1 row)

更多学习教程公众号风哥教程itpux_com

# 生产环境压力测试案例

# 1. 测试场景
# – 模拟生产环境负载
# – 测试系统承载能力
# – 发现性能瓶颈
# – 优化系统配置

# 2. 测试数据准备
# 生成测试数据
psql -d fgedudb << SQL CREATE TABLE fgedu.fgedu_test_data AS SELECT generate_series(1, 10000000) AS id, random() * 10000 AS value1, random() * 10000 AS value2, CURRENT_DATE - (random() * 365)::int AS date_value, md5(random()::text) AS text_value; SQL # 3. 测试脚本 $ cat > /GreenPlum/scripts/pressure_test.sh << 'EOF' #!/bin/bash # pressure_test.sh # from:www.itpux.com.qq113257174.wx:itpux-com # web: http://www.fgedu.net.cn LOG_FILE="/GreenPlum/logs/pressure_test_$(date +%Y%m%d).log" echo "开始压力测试" | tee -a $LOG_FILE # 测试1：简单查询 echo "测试1：简单查询" | tee -a $LOG_FILE time psql -d fgedudb -c "SELECT count(*) FROM fgedu.fgedu_test_data;" | tee -a $LOG_FILE # 测试2：聚合查询 echo "测试2：聚合查询" | tee -a $LOG_FILE time psql -d fgedudb -c "SELECT date_value, sum(value1) FROM fgedu.fgedu_test_data GROUP BY date_value;" | tee -a $LOG_FILE # 测试3：复杂查询 echo "测试3：复杂查询" | tee -a $LOG_FILE time psql -d fgedudb -c " SELECT date_value, count(*) as cnt, sum(value1) as sum_v1, avg(value2) as avg_v2 FROM fgedu.fgedu_test_data WHERE date_value >= CURRENT_DATE – 30
GROUP BY date_value
ORDER BY date_value;” | tee -a $LOG_FILE

echo “压力测试完成” | tee -a $LOG_FILE
EOF

# 4. 执行测试
$ /GreenPlum/scripts/pressure_test.sh

# 5. 结果分析
# – 简单查询：0.5秒
# – 聚合查询：5秒
# – 复杂查询：10秒
# – 系统资源：CPU 80%，内存 60%，IO 50%

from GreenPlum视频:www.itpux.com

压力测试技巧：

1. 测试准备
– 制定测试计划
– 准备测试数据
– 配置测试环境
– 设置监控

2. 测试执行
– 逐步增加负载
– 监控系统资源
– 记录测试数据
– 观察性能指标

3. 结果分析
– 分析响应时间
– 分析吞吐量
– 分析资源使用
– 识别瓶颈

4. 系统优化
– 参数调优
– 索引优化
– 查询优化
– 硬件升级

5. 最佳实践
– 模拟真实场景
– 多次测试验证
– 持续优化改进
– 建立性能基线

本文档介绍了GreenPlum压力测试的核心内容，包括基准测试、并发测试、压力测试案例等，希望对大家有所帮助。