Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit4b3bfce

Browse files
author
Your Name
committed
Changed scripts after the experiments
1 parent110b8a6 commit4b3bfce

File tree

5 files changed

+58
-4
lines changed

5 files changed

+58
-4
lines changed

‎pgb_fdw.sh

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -15,7 +15,9 @@ export PGDATABASE=shardman
1515
export PGHOST=localhost
1616
export PGUSER=`whoami`
1717

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&
2123

‎pgb_fdw_test.sh

Lines changed: 28 additions & 0 deletions
Original file line numberDiff line numberDiff 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+

‎pgb.shrenamed to‎pgb_init.sh

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,8 +20,10 @@ initdb -D $M
2020

2121
#echo "work_mem = 2GB" >> $M/postgresql.conf
2222
#echo "shared_buffers = 2GB" >> $M/postgresql.conf
23+
echo"max_connections = 10000">>$M/postgresql.conf
24+
2325
pg_ctl -w -D$M -l logfile.log start
2426
createdb$U
2527
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
2729

‎pgb_test.sh

Lines changed: 19 additions & 0 deletions
Original file line numberDiff line numberDiff 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

‎shdep.sh

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -47,6 +47,9 @@ initdb -D $D3 -E UTF8 --locale=C
4747
echo"shared_preload_libraries = 'postgres_fdw'">>$D1/postgresql.conf
4848
echo"shared_preload_libraries = 'postgres_fdw'">>$D2/postgresql.conf
4949
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
5053
#echo "shared_buffers = 10GB" >> $D1/postgresql.conf
5154
#echo "shared_buffers = 10GB" >> $D2/postgresql.conf
5255
#echo "shared_buffers = 10GB" >> $D3/postgresql.conf

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp