1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
#-------------------------------------------------------------------------
#
# Makefile--
# Makefile for the Wisconsin Benchmark
#
# Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
# Portions Copyright (c) 1994-5, Regents of the University of California
#
#
# IDENTIFICATION
# $PostgreSQL: pgsql/src/test/bench/Makefile,v 1.16 2008/03/18 16:24:50 petere Exp $
#
#-------------------------------------------------------------------------
subdir = src/test/bench
top_builddir = ../../..
include $(top_builddir)/src/Makefile.global
CREATEFILES= create.sql bench.sql
OUTFILES= bench.out bench.out.perquery
all: $(CREATEFILES)
rm -f $(OUTFILES)
create.sql: create.source
rm -f $@; \
C=`pwd`; \
sed -e "s:_CWD_:$$C:g" < $< > $@
bench.sql:
x=1; \
for i in `ls query[0-9][0-9]`; do \
echo "select $$x as x" >> bench.sql && \
cat $$i >> bench.sql && \
x=`expr $$x + 1` || exit; \
done
runtest: $(OUTFILES)
bench.out: $(CREATEFILES)
$(SHELL) ./create.sh $$PGDATA && \
$(SHELL) ./runwisc.sh $$PGDATA > $@
@echo "RESULTS OF BENCHMARK ARE SAVED IN FILE bench.out";
bench.out.perquery: bench.out
$(SHELL) ./perquery <bench.out > $@
@echo "BREAKDOWN OF BENCHMARK IS SAVED IN FILE bench.out.perquery";
clean:
rm -f $(OUTFILES) $(CREATEFILES)