pgsql的测试，这是啥情况？
十来分钟以后再测，又到三位数了。接着测，一次比一次高，最高一次上万了。
是不是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 于 2013-11-08 12:43 编辑
测试环境呢？参数配置等等 回复 2# gvim
没有经过特殊的优化，只进行了最基础的内存参数。 这个不知道呢。。。顶你一下
页:
[1]