RDBMS Information - PostgreSQL - Performance monitor with PGBENCH

This page provides a way to check if the Database Server where you will run the PGBench has performance issues.

1. Create a batch and copy the below content after having changed the parameter

   @echo off
   @echo off
   set PGPASSWORD=CastAIP
   set PGHOST=<YOUR POSTGRESQL SERVER NAME>
   set PGPORT=<THE PORT>
     
   set EXEDIR=%ProgramFiles%\CAST\CASTStorageService3\bin
   "%EXEDIR%\createdb" -U operator pgbench
   "%EXEDIR%\pgbench" -i -s 10 -F 10  -U operator pgbench
   @echo on
   "%EXEDIR%\pgbench" -U operator -c 5 -T180 pgbench > %TEMP%\pgbench.txt
   @echo off
   "%EXEDIR%\psql" -c "drop database pgbench" postgres operator
     
   type %TEMP%\pgbench.txt
   pause

   
   

2. Execute the batch file

3. A text file will be generated in %TEMP% folder, the name is pgbench.txt.