pgload.jmx is JMX file you can load into Jmeter and run a substantial load on a Postgres database. Should work just as well on Oracle if you change the test SQL from “Select 1″ to “select 1 from dual”
Install jmeter on our machine . On my mac, I did
- brew install jmeter
You will need the Postgres driver. I used
- postgresql-9.4-jdbc4.jar from https://jdbc.postgresql.org/download.html
- Put it in the classpath in jmeter
To use this file, save it as pgload.jmx and then open it up with Jmeter. Change the database URL with host, port, database name, and fill in your username and password.
The database URL looks like jdbc:postgresql://mydb.machine.com:5432/postgres
Then just hit the green triangle to start the load.
The load will create a table named authors, a sequence called serial and an index called author_id if these don’t already exist.
It will then run inserts, deletes, updates and selects on this table.