The following bug has been logged on the website:

Bug reference:      8326
Logged by:          digoal.zhou
Email address:      dig...@126.com
PostgreSQL version: Unsupported/Unknown
Operating system:   CentOS 5.8 x64
Description:        

when client thread big, the tps without connection time wrong!!!!
pg94@db-172-16-3-33-> pgbench  -M prepared -n -r -f ./test.sql -T 10 -c 800
-j 100 digoal
transaction type: Custom query
scaling factor: 1
query mode: prepared
number of clients: 800
number of threads: 100
duration: 10 s
number of transactions actually processed: 2037960
tps = 199534.267305 (including connections establishing)
tps = 675603.691013 (excluding connections establishing)
statement latencies in milliseconds:
        1.019046        select 1;


when client threads small, the wrong is little.
pg94@db-172-16-3-33-> pgbench  -M prepared -n -r -f ./test.sql -T 10 -c 800
-j 10 digoal
transaction type: Custom query
scaling factor: 1
query mode: prepared
number of clients: 800
number of threads: 10
duration: 10 s
number of transactions actually processed: 1035345
tps = 102285.117970 (including connections establishing)
tps = 115616.181725 (excluding connections establishing)
statement latencies in milliseconds:
        6.812371        select 1;



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to