A
A
Anton2020-04-26 14:44:40
PostgreSQL
Anton, 2020-04-26 14:44:40

What are some java projects (open source) that can measure performance of SELECT with PostgreSQL from master only or from master + replicas?

jdbc driver can send requests to Slave:

jdbc:postgresql://node1,node2,node3/accounting?targetServerType=master
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=preferSlave&loadBalanceHosts=true


https://jdbc.postgresql.org/documentation/94/conne...

That is, you can make a benchmark of how a java application works when working with postgres only with master or with master + slave.

https://github.com/8kdata/javapgperf is not suitable as it measures query times and I need TPS

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton, 2020-04-26
Patsev @chemtech

Searched. Perhaps these will work:
https://github.com/oltpbenchmark/oltpbench
https://github.com/petergeoghegan/benchmarksql
https://github.com/jopereira/java-tpcw
https://github.com/rmpvilaca/EscadaTPC -C
https://github.com/jacobNil/java-tpcw

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question