论坛徽章:: 54

电梯直达

1楼 [收藏(0)] [报告]

发表于 2013-11-06 14:22 |只看该作者 |倒序浏览

十来分钟以后再测，又到三位数了。
接着测，一次比一次高，最高一次上万了。

是不是FreeBSD某个缓存起作用了？但是很快又清空/重置了。

BTW：测试了插入和SELECT，总是比mysql慢一点，但是网上都说在FB下要比mysql好不少。

root@test:/# pgbench -t 2000 -c 4 -U pgsql test
……
tps = 385.099944 (including connections establishing)
tps = 385.632404 (excluding connections establishing)
root@ytest:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 1795.183075 (including connections establishing)
tps = 1833.380543 (excluding connections establishing)
root@test:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 4026.897663 (including connections establishing)
tps = 4059.588672 (excluding connections establishing)
root@test:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 5768.235194 (including connections establishing)
tps = 5808.567056 (excluding connections establishing)
root@test:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 6240.877592 (including connections establishing)
tps = 6290.470331 (excluding connections establishing)
root@test:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 7221.422349 (including connections establishing)
tps = 7252.841301 (excluding connections establishing)
root@test:/ # pgbench -t 2000 -c 4 -U pgsql test
……
tps = 6860.016224 (including connections establishing)
tps = 6888.220540 (excluding connections establishing)

文库|博客

gvim

版主

论坛徽章:: 2

2楼 [报告]

发表于 2013-11-08 12:42 |只看该作者

本帖最后由 gvim 于 2013-11-08 12:43 编辑

测试环境呢？参数配置等等

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

Hongqiyaodao Hongqiyaodao 当前离线禁止发言好友博客消息论坛徽章: 29	3楼 [报告] 发表于 2013-11-08 13:48 \|只看该作者提示: 作者被禁止或删除内容自动屏蔽
	实战分享：从技术角度谈机器学习入门\| 【大话IT】RadonDB低门槛向MySQL集群下战书 \| ChinaUnix打赏功能已上线！ \| 新一代分布式关系型数据库RadonDB知多少？