423,688 Members | 1,879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

Benchmark testing with pgbench in postgres BDR set up

P: 1
Hi ,

I am getting constant TPS as 500 while using pgbench with different TPS as input .
How to increase the TPS in BDR set up, please suggest .
Expand|Select|Wrap|Line Numbers
  1.        bdr_version used :  1.0.3-2017-11-21-15283ba
  2.  
  3. ******************** Sample Output and pgbench command input **********************************************************
  4. Scenario 1 :  Shared_Buffer = 1024 MB and throttling TPS  as 2000
  5.  
  6. command used :  pgbench -h <hostname> -p 5432 -U postgres -d <dbname> -c 50 -j 50  -r -R 2000
  7.  
  8. O/P : 
  9. transaction type: TPC-B (sort of)
  10. scaling factor: 1
  11. query mode: simple
  12. number of clients: 50
  13. number of threads: 50
  14. duration: 2400 s
  15. number of transactions actually processed: 1200964
  16. latency average: 894071.370 ms
  17. latency stddev: -nan ms
  18. rate limit schedule lag: avg 893971.489 (max 1819008.190) ms
  19. tps = 500.382936 (including connections establishing)
  20. tps = 500.385107 (excluding connections establishing)
  21. statement latencies in milliseconds:
  22.         0.109225        \set nbranches 1 * :scale
  23.         0.100045        \set ntellers 10 * :scale
  24.         0.085917        \set naccounts 100000 * :scale
  25.         0.064758        \setrandom aid 1 :naccounts
  26.         0.057230        \setrandom bid 1 :nbranches
  27.         0.052089        \setrandom tid 1 :ntellers
  28.         0.049827        \setrandom delta -5000 5000
  29.         0.471368        BEGIN;
  30.         0.678317        UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
  31.         0.599331        SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
  32.         80.328257       UPDATE pgbench_tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
  33.         15.537372       UPDATE pgbench_branches SET bbalance = bbalance + :delta WHERE bid = :bid;
  34.         0.698180        INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
  35.         0.995450        END;
  36. Thu Aug 16 09:52:30 UTC 2018
  37. __________________________________________________________________________________________________________________________
  38.  
Expand|Select|Wrap|Line Numbers
  1. Scenario 2: Shared_Buffer = 1024 MB and throttling TPS  as 6000
  2. Command Used  : pgbench -h <hostname> -p 5432 -U postgres -d <dbname> -c 50 -j 50  -r -R 6000
  3.  
  4. O/P :
  5. transaction type: TPC-B (sort of)
  6. scaling factor: 1
  7. query mode: simple
  8. number of clients: 50
  9. number of threads: 50
  10. duration: 2400 s
  11. number of transactions actually processed: 1184746
  12. latency average: 1096729.554 ms
  13. latency stddev: -nan ms
  14. rate limit schedule lag: avg 1096628.305 (max 2208483.098) ms
  15. tps = 493.625936 (including connections establishing)
  16. tps = 493.629106 (excluding connections establishing)
  17. statement latencies in milliseconds:
  18.         0.108491        \set nbranches 1 * :scale
  19.         0.098740        \set ntellers 10 * :scale
  20.         0.084497        \set naccounts 100000 * :scale
  21.         0.064168        \setrandom aid 1 :naccounts
  22.         0.056658        \setrandom bid 1 :nbranches
  23.         0.051678        \setrandom tid 1 :ntellers
  24.         0.049427        \setrandom delta -5000 5000
  25.         0.480755        BEGIN;
  26.         0.696514        UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
  27.         0.607114        SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
  28.         81.404448       UPDATE pgbench_tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
  29.         15.775295       UPDATE pgbench_branches SET bbalance = bbalance + :delta WHERE bid = :bid;
  30.         0.708403        INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
  31.         1.009272        END;
  32. Thu Aug 16 11:33:17 UTC 2018
Aug 22 '18 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,285
soumitra1234
What have you already tried?
People here do not have your setup so really need to know what you have already tried so that they have some idea about your skill set and your work environment.
Aug 22 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.