On 11/07/2015 11:27 PM, Tim Chou wrote:
Hi All,
When I test the DBT2 with a large number of connections, I always get
the error:
Error in read.table(file = file, header = header, sep = sep, quote =
quote, :
no lines available in input
Calls: read.csv -> read.table
I have tracked the file and see the reason is there are no "TERMINATED"
in mix.log.
However, in my observation, driver and client do not close elegantly so
they cannot quit with sprintf with the "TERMINATED" message (These
threads are closed by killall command).
1. How can I solve the problem? (I have checked the bash script and c
code. I don't know why each thread cannot exit from the main loop after
the predefined time. It should exit the main loop at time xxxx, which is
a pre-computed value, according to the code.)
2. I want to know if my performance is too low.
No matter how I change the parameters, like creating RAM disk, improving
the connection number, I always get the similar results.
Here is one of my test results:
Hardware: 4-core, 16GB of memory, two disks, and 1Gb ethernet
Parameters: 10 warehouses, 30 connections.
Response Time (s)
Transaction % Average : 90th % Total
Rollbacks %
------------ ----- --------------------- ----------- ---------------
-----
Delivery 3.00 0.012 : 0.018 7
0 0.00
New Order 41.63 0.006 : 0.008 97
0 0.00
Order Status 5.58 0.003 : 0.004 13 0
0.00
Payment 47.64 0.003 : 0.004 111
0 0.00
Stock Level 2.15 0.005 : 0.007 5
0 0.00
------------ ----- --------------------- ----------- ---------------
-----
118.78 new-order transactions per minute (NOTPM)
0.8 minute duration
0 total unknown errors
97.0 seconds(s) ramping up
It seems only 2 txns/sec. Is that too low? How can I improve the
performance?
3. How can I test the performance in distributed mode?
Looking forward to your replies.
What version of Postgres?
Where did get the DBT2 test?
How did you run the test?
Thanks,
Tim
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
