home *** CD-ROM | disk | FTP | other *** search
/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre1.z / postgre1 / bench / create.sh next >
Encoding:
Linux/UNIX/POSIX Shell Script  |  1992-08-27  |  700 b   |  37 lines
  1. #!/bin/sh
  2. # $HEADER:
  3. # 
  4. # wisconsin.sh - populates and runs the wisconsin benchmark on a database
  5. # named "bench".
  6. #
  7.  
  8. if (test ! -z "$POSTGRESHOME")
  9. then
  10.     PGHOME=$POSTGRESHOME
  11. else
  12.     PGHOME=/usr/postgres
  13. fi
  14.  
  15. POSTGRES=$PGHOME/bin/postgres
  16. POSTMASTER=$PGHOME/bin/postmaster
  17. CREATEDB=$PGHOME/bin/createdb.sh
  18. VCONTROL=$PGHOME/bin/vcontrol
  19. MAKE=/bin/make
  20.  
  21. echo ===== creating benchmark database ======
  22.  
  23. $CREATEDB bench
  24.  
  25. echo ===== populating initial classes ======
  26.  
  27. for i in querycreat querycopy querydefineindex queryBprime
  28. do
  29.     echo Running $i....
  30.     $POSTGRES -Q bench < $i > /dev/null
  31. done
  32.  
  33. echo ===== vacuuming bench database ======
  34. echo "vacuum" | $POSTGRES -Q bench > /dev/null
  35.  
  36. echo done 
  37.