PostgreSQL 性能测试工具
发布时间:2020-12-13 17:12:27 所属栏目:百科 来源:网络整理
导读:postgresql 自带性能测试工具 pgbench pgbench 是 postgresql 自带的交互性能测试工具。用于测试postgresql数据库性能。 为了测试postgresql数据库性能,简单测试如下 bash-4.2$ pgbench --helppgbench is a benchmarking tool for PostgreSQL.Usage: pgbenc
postgresql 自带性能测试工具 pgbench 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
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |