Commit4b3bfce

Your Name

committed

Changed scripts after the experiments

1 parent110b8a6 commit4b3bfceCopy full SHA for 4b3bfce

File tree

+58

-4

lines changed

+58

-4

lines changed

Lines changed: 5 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -15,7 +15,9 @@ export PGDATABASE=shardman`
`15`	`15`	`export PGHOST=localhost`
`16`	`16`	export PGUSER=`whoami`
`17`	`17`
`18`		`-pgbench -p 5432 -T 60 -P 5 -c 5 -j 5 --select-only -n&`
`19`		`-pgbench -p 5433 -T 60 -P 5 -c 5 -j 5 --select-only -n&`
`20`		`-pgbench -p 5434 -T 60 -P 5 -c 5 -j 5 --select-only -n&`
	`18`	`+cl=200`
	`19`	`+`
	`20`	`+pgbench -p 5432 -T 20 -P 5 -c$cl -j$cl --select-only -n&`
	`21`	`+pgbench -p 5433 -T 20 -P 5 -c$cl -j$cl --select-only -n&`
	`22`	`+pgbench -p 5434 -T 20 -P 5 -c$cl -j$cl --select-only -n&`
`21`	`23`

Lines changed: 28 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,28 @@`
	`1`	`+#!/bin/bash`
	`2`	`+`
	`3`	`+# ##############################################################################`
	`4`	`+#`
	`5`	`+# Use pgbench to scale OLTP load with FDW + partitioning machinery`
	`6`	`+#`
	`7`	`+# ##############################################################################`
	`8`	`+`
	`9`	+PGINSTALL=`pwd`/tmp_install/
	`10`	`+`
	`11`	`+export LD_LIBRARY_PATH=$PGINSTALL/lib:$LD_LIBRARY_PATH`
	`12`	`+export PATH=$PGINSTALL/bin:$PATH`
	`13`	`+`
	`14`	`+export PGDATABASE=shardman`
	`15`	`+export PGHOST=localhost`
	`16`	+export PGUSER=`whoami`
	`17`	`+`
	`18`	+pkill -U`whoami` -9 -e postgres
	`19`	+pkill -U`whoami` -9 -e pgbench
	`20`	`+`
	`21`	`+pg_ctl -D PGDATA1 -l n0.log start`
	`22`	`+pg_ctl -o"-p 5433" -D PGDATA2 -l n1.log start`
	`23`	`+pg_ctl -o"-p 5434" -D PGDATA3 -l n2.log start`
	`24`	`+`
	`25`	`+pgbench -p 5432 -T 60 -P 5 -c 100 -j 33 --select-only -n&`
	`26`	`+pgbench -p 5433 -T 60 -P 5 -c 100 -j 33 --select-only -n&`
	`27`	`+pgbench -p 5434 -T 60 -P 5 -c 100 -j 33 --select-only -n&`
	`28`	`+`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -20,8 +20,10 @@ initdb -D $M`
`20`	`20`
`21`	`21`	`#echo "work_mem = 2GB" >> $M/postgresql.conf`
`22`	`22`	`#echo "shared_buffers = 2GB" >> $M/postgresql.conf`
	`23`	`+echo"max_connections = 10000">>$M/postgresql.conf`
	`24`	`+`
`23`	`25`	`pg_ctl -w -D$M -l logfile.log start`
`24`	`26`	`createdb$U`
`25`	`27`	`pgbench -i -s 300`
`26`		`-pgbench -T 60 -c15 -j15 -P 5 --select-only -n$U`
	`28`	`+#pgbench -T 60 -c100 -j100 -P 5 --select-only -n $U`
`27`	`29`

Lines changed: 19 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,19 @@`
	`1`	`+#!/bin/bash`
	`2`	`+`
	`3`	+INSTDIR=`pwd`/tmp_install
	`4`	`+export LD_LIBRARY_PATH=$INSTDIR/lib:$LD_LIBRARY_PATH`
	`5`	`+export PATH=$INSTDIR/bin:$PATH`
	`6`	`+export PGPORT=5438`
	`7`	`+export PGHOST=localhost`
	`8`	+export PGDATABASE=`whoami`
	`9`	`+`
	`10`	+pkill -U`whoami` -9 -e postgres
	`11`	+pkill -U`whoami` -9 -e pgbench
	`12`	`+`
	`13`	+M=`pwd`/PGDATA
	`14`	+U=`whoami`
	`15`	`+`
	`16`	`+rm -rf logfile.log\|\|true`
	`17`	`+pg_ctl -w -D$M -l logfile.log start`
	`18`	`+pgbench -T 20 -c 10 -j 10 -P 5 --select-only -n$U`
	`19`	`+pg_ctl -D$M stop`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -47,6 +47,9 @@ initdb -D $D3 -E UTF8 --locale=C`
`47`	`47`	`echo"shared_preload_libraries = 'postgres_fdw'">>$D1/postgresql.conf`
`48`	`48`	`echo"shared_preload_libraries = 'postgres_fdw'">>$D2/postgresql.conf`
`49`	`49`	`echo"shared_preload_libraries = 'postgres_fdw'">>$D3/postgresql.conf`
	`50`	`+echo"max_connections = 100000">>$D1/postgresql.conf`
	`51`	`+echo"max_connections = 100000">>$D2/postgresql.conf`
	`52`	`+echo"max_connections = 100000">>$D3/postgresql.conf`
`50`	`53`	`#echo "shared_buffers = 10GB" >> $D1/postgresql.conf`
`51`	`54`	`#echo "shared_buffers = 10GB" >> $D2/postgresql.conf`
`52`	`55`	`#echo "shared_buffers = 10GB" >> $D3/postgresql.conf`

Comments

(0)