README

text/plain

Download

README for test.sh
------------------

Preparation
-----------
Before running the benchmark script, perform the following steps:

1. Create a database if you want to run the test on a database other than "postgres":
   createdb mydb

2. Initialize pgbench tables with a scaling factor of 100:
   pgbench -U postgres -i -s 100 postgres

3. Set environment variables for the script if they differ from the defaults.
- PGUSER    – database user (default: postgres)
- PGDB      – database name (default: postgres)

Script Description
------------------
The test.sh script runs benchmark scenario consisting of:

1. Background load that repeatedly creates and drops temporary tables with indexes in a loop, generating frequent cache invalidations. 

2. Main benchmark – pgbench select-only scenario with 64 clients
pgbench -U "$PGUSER" -d "$PGDB" -c 64 -j 32 -T 20 -s 100 -M prepared -b select-only -n

Example:
   export PGDB=test ./test.sh