关闭

PostgreSQL 性能测试工具

标签: postgresql性能测试测试性能数据库
1993人阅读 评论(1) 收藏 举报
分类:

postgresql 自带性能测试工具 pgbench
pgbench 是 postgresql 自带的交互性能测试工具。用于测试postgresql数据库性能。
为了测试postgresql数据库性能,简单测试如下

bash-4.2$ pgbench --help
pgbench is a benchmarking tool for PostgreSQL.

Usage:
  pgbench [OPTION]... [DBNAME]

Initialization options:
  -i           invokes initialization mode
  -F NUM       fill factor
  -s NUM       scaling factor
  --index-tablespace=TABLESPACE
               create indexes in the specified tablespace
  --tablespace=TABLESPACE
               create tables in the specified tablespace
  --unlogged-tables
               create tables as unlogged tables

Benchmarking options:
  -c NUM       number of concurrent database clients (default: 1)
  -C           establish new connection for each transaction
  -D VARNAME=VALUE
               define variable for use by custom script
  -f FILENAME  read transaction script from FILENAME
  -j NUM       number of threads (default: 1)
  -l           write transaction times to log file
  -M simple|extended|prepared
               protocol for submitting queries to server (default: simple)
  -n           do not run VACUUM before tests
  -N           do not update tables "pgbench_tellers" and "pgbench_branches"
  -r           report average latency per command
  -s NUM       report this scale factor in output
  -S           perform SELECT-only transactions
  -t NUM       number of transactions each client runs (default: 10)
  -T NUM       duration of benchmark test in seconds
  -v           vacuum all four standard tables before tests

Common options:
  -d             print debugging output
  -h HOSTNAME    database server host or socket directory
  -p PORT        database server port number
  -U USERNAME    connect as specified database user
  -V, --version  output version information, then exit
  -?, --help     show this help, then exit

Report bugs to <pgsql-bugs@postgresql.org>.

  • 测试数据库初始化
pgbench -i pgbench

生成8千万数据的测试库

pgbench -i  -s 800 pgbench

生成20亿测试数据(海量数据生成,生成速度看机器配置)

pgbench -i-s 20000 pgbench

单独安装,postgresql94-contrib

yum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm 
yum install  postgresql94-contrib

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:128603次
    • 积分:2923
    • 等级:
    • 排名:第12784名
    • 原创:134篇
    • 转载:16篇
    • 译文:19篇
    • 评论:15条
    文章分类
    最新评论
    我的博客
    我的搜索