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

Commit7e96269

Browse files
committed
Various pgbench enhancements. Patch contributed by ITAGAKI Takahiro.
Also tweak README.pgbench/README.pgbench_jis: Remove history after pgbench was added to PostgreSQL contrib module. Those info was not only redundant since it has already been in CVS log, but also incomplete.--------------------------------------------------------------------------The attached is a patch to optimize contrib/pgbench using new 8.3 features.- Use DROP IF EXISTS to suppress errors for initial loadings.- Use a combination of TRUNCATE and COPY to reduce WAL on creating the accounts table.Also, there are some cosmetic changes.- Change the output of -v option from "starting full vacuum..." to "starting vacuum accounts..." in reflection of the fact.- Shape duplicated error checks into executeStatement().There is a big performance win in "COPY with no WAL" feature.Thanks for the efforts!--------------------------------------------------------------------------
1 parent37a609b commit7e96269

File tree

3 files changed

+75
-254
lines changed

3 files changed

+75
-254
lines changed

‎contrib/pgbench/README.pgbench

Lines changed: 4 additions & 49 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,6 @@
1-
pgbench README2006/10/21 Tatsuo Ishii
1+
$PostgreSQL: pgsql/contrib/pgbench/README.pgbench,v 1.16 2007/04/06 08:49:44 ishii Exp $
2+
3+
pgbench README
24

35
o What is pgbench?
46

@@ -233,54 +235,7 @@ o License?
233235

234236
Basically it is same as BSD license. See pgbench.c for more details.
235237

236-
o History
237-
238-
2006/10/21
239-
* more fix with handling default scaling factor in the default
240-
scenarios
241-
242-
2006/09/14
243-
* change "tps" to "scale" to avoid confusion
244-
245-
* fix bug with handling default scaling factor in the default
246-
scenarios
247-
248-
2006/07/26
249-
* New features contributed by Tomoaki Sato.
250-
251-
* predefined variable "tps"
252-
The value of variable tps is taken from the scaling factor
253-
specified by -s option.
254-
* -D option
255-
Variable values can be defined by -D option.
256-
* \set command now allows arithmetic calculations.
257-
258-
2005/09/29
259-
* add -f option. contributed by Tomoaki Sato.
260-
261-
[updation records were missing]
262-
263-
2003/11/26
264-
* create indexes after data insertion to reduce time.
265-
patch from Yutaka Tanida.
266-
267-
2003/06/10
268-
* fix uninitialized memory bug
269-
* add support for PGHOST, PGPORT, PGUSER environment variables
270-
271-
2002/07/20
272-
* patch contributed by Neil Conway.
273-
* code/document clean up and add -l option.
274-
275-
2002/02/24
276-
* do not CHECKPOINT anymore while initializing benchmark
277-
* database. Add -N option.
278-
279-
2001/10/24
280-
* "time"->"mtime"
281-
282-
2001/09/09
283-
* Add -U, -P, -C options
238+
o History before contributed to PostgreSQL
284239

285240
2000/1/15 pgbench-1.2 contributed to PostgreSQL
286241
* Add -v option

‎contrib/pgbench/README.pgbench_jis

Lines changed: 4 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,6 @@
1-
pgbench README2006/10/21 Tatsuo Ishii
1+
$PostgreSQL: pgsql/contrib/pgbench/README.pgbench_jis,v 1.17 2007/04/06 08:49:44 ishii Exp $
2+
3+
pgbench README
24

35
$B"#(Bpgbench $B$H$O!)(B
46

@@ -283,57 +285,7 @@ pgbench $B$O@P0f(B $BC#IW$K$h$C$F=q$+$l$^$7$?!%%i%$%;%s%9>r7o$O(B pgbench.c
283285
$BKAF,$K=q$$$F$"$j$^$9!%$3$N>r7o$r<i$k8B$jL5=~$GMxMQ$7!$$^$?<+M3$K:FG[IU(B
284286
$B$G$-$^$9!%(B
285287

286-
$B"#2~DjMzNr(B
287-
288-
2006/10/21
289-
* $B99$K%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?$r(Bbranches$B$+$i<h$C$F$3$J(B
290-
$B$$%P%0$r=$@5!%(B
291-
292-
2006/09/13
293-
* $BJQ?t(Btps$B$OJ6$i$o$7$$$N$G(Bscale$B$KJQ99!%%G%U%)%k%H%7%J%j%*$N;~$K!$(B
294-
$B%G%U%)%k%H$N%9%1!<%j%s%0%U%!%/%?$r(Bbranches$B$+$i<h$C$F$3$J$$%P%0$r=$@5!%(B
295-
296-
2006/07/26
297-
* $B:4F#$5$s$N%Q%C%A$rE,MQ!%0J2<$N5!G=DI2C!%(BPostgreSQL 8.2$B$K<h$j(B
298-
$B9~$^$l$^$9!%(B
299-
300-
$BJQ?t(B tps
301-
-s $B%*%W%7%g%s$G;XDj$7$?%9%1!<%j%s%0%U%!%/%?!<$r%U%!%$%kFb$GJQ?t$H$7(B
302-
$B$F;2>H$9$k5!G=(B
303-
-D $B%*%W%7%g%s(B
304-
$B%3%^%s%I$N%*%W%7%g%s$H$7$FDj5A$7$?JQ?t$r%U%!%$%kFb$+$i;2>H$9$k5!G=(B
305-
\set $B%3%^%s%I(B
306-
$B%U%!%$%kFb$G;MB'1i;;$r9T$$!"$=$N7k2L$rJQ?t$KBeF~$9$k5!G=(B
307-
308-
2005/09/29
309-
* $B:4F#$5$s$N%Q%C%A$rE,MQ!%(B-f $B%*%W%7%g%s$NDI2C!%(B
310-
311-
[$B$3$N4V$$$m$$$mJQ99$,$"$C$?$h$&$@$,(BREADME$B$O%a%$%s%F%J%s%9$5$l$F$$$J$$(B]
312-
313-
2003/11/26
314-
* $BC+ED$5$s$N%Q%C%A$rE,MQ!%(Bpgbench -i$B$N:]$K!$8e$+$i<g%-!<$r:n@.(B
315-
$B$9$k$h$&$K$7$?!%$3$l$K$h$C$F=i4|2=$N<B9T;~4V$,BgI}$KC;=L$G$-(B
316-
$B$k(B($B$O$:(B)$B!%(B
317-
318-
2003/06/10
319-
* $B%a%b%j$,=i4|2=$5$l$F$$$J$$%P%0$r=$@5(B
320-
* $B4D6-JQ?t(BPGHOST, PGPORT, PGUSER$B$rG'<1$9$k$h$&$K$7$?!%(B
321-
322-
2002/07/20
323-
* Nei Conway$B$5$s$N%Q%C%A$rE,MQ!%(B
324-
* -l $B%*%W%7%g%s$NDI2C!%(B
325-
326-
2002/02/24
327-
* $B$3$3$+$i$O(B7.3$BMQ$NJQ99$G$9!%(B
328-
* CHECKPOINT$B$NH/9T$r$d$a$^$7$?!%(B
329-
* -N $B%*%W%7%g%s$rDI2C$7$^$7$?!%(B
330-
331-
2001/10/24
332-
* PostgreSQL 7.2$B$G!$(B"time"$B$,M=Ls8l$K$J$C$?$N$G!$(B"mtime"$B$KJQ99(B
333-
$B$7$?!%(B
334-
335-
2001/09/09
336-
* PostgreSQL 7.2$BMQ$K!$(B-U, -P, -C $B%*%W%7%g%s$rDI2C$7$^$7$?!%(B
288+
$B"#(BPostgreSQL$B$N(Bcontrib$B%b%8%e!<%k$H$7$F<h$j9~$^$l$k$^$G$N2~DjMzNr(B
337289

338290
2000/1/15 pgbench-1.2 $B$O(B PostgreSQL $B$K(B contribute $B$5$l$^$7$?!%(B
339291
* -v $B%*%W%7%g%sDI2C(B

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp