summaryrefslogtreecommitdiff
path: root/contrib/pgbench
Commit message (Collapse)AuthorAgeFilesLines
* Fix core dump recently introduced into pgbench.Tom Lane2002-10-201-2/+1
|
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-181-2/+23
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Avoid PQisBusy/PQconsumeInput busy loop in case of PQisBusy returningTatsuo Ishii2002-10-071-21/+19
| | | | | | | | | | | | false. per Tom Lane's suggestion. See: Subject: Suggested change to pgbench From: Tom Lane <tgl@sss.pgh.pa.us> To: Tatsuo Ishii <t-ishii@sra.co.jp> Cc: pgsql-patches@postgreSQL.org Date: Sun, 06 Oct 2002 12:37:27 -0400 for more details.
* pgindent run.Bruce Momjian2002-09-041-22/+28
|
* The attached patch changes most of the usages of sprintf() toBruce Momjian2002-08-151-10/+10
| | | | | | | | | snprintf() in contrib/. I didn't touch the places where pointer arithmatic was being used, or other areas where the fix wasn't trivial. I would think that few, if any, of the usages of sprintf() were actually exploitable, but it's probably better to be paranoid... Neil Conway
* Apply patches from Neil Conway.Tatsuo Ishii2002-07-203-40/+100
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > Hi Tatsuo, > > I've attached a patch for the version of pgbench in CVS. It includes the > following changes: > > - fix some spelling mistakes, indentation stuff, etc. > > - minor code cleanup -- (void) args instead of (), etc. > > - allocate the state array dynamically, so that it is only as > large as needed. This reduces the memory consumption of pgbench > slightly, and makes a larger MAXCLIENTS setting possible > > - (the only controversial change) add an option "-l" to log > transaction latencies to a file. The "transaction latency" > is the time between when the BEGIN is issued and the transaction > commits. This is written to a file, along with the client # > and the transaction #. The data in the file can then be used > for things like: > > - consistency analysis: is the TPS the same through the > entire run of pgbench, or does it change? > > - more detailed stats: what is the average latency, worse-case > latency, best-case latency? > > - graphs: feed the data to gnuplot, graph latency versus. time > > - etc. > > I was going to store this data in memory and write it to disk > at the end of the pgbench run, but that isn't feasible because > the data can be very large: for example, ~70MB if benchmarking > 128 clients doing 100,000 transactions each. > > Cheers, > > Neil
* Update docs about new -N optionTatsuo Ishii2002-05-202-8/+13
|
* Add -N option which disables updation of branches and tellers tables.Tatsuo Ishii2002-02-243-18/+67
| | | | | So there would be less contention with -N, that might be more realistic test.
* Remove CHECKPOINT call from pgbench -- Not needed and affects performance.Bruce Momjian2002-02-181-11/+1
|
* The result of getopt() should be compared to -1, not EOF, perTom Lane2002-01-101-2/+2
| | | | pgsql-hackers discussion of this date.
* New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian2001-11-051-5/+5
| | | | initdb/regression tests pass.
* pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian2001-10-251-74/+75
| | | | tests pass.
* "time" is now a reserved keyword(changed to "mtime").Tatsuo Ishii2001-10-243-6/+13
|
* Add -U, -P, -C options. See README.pgbench for more details.Tatsuo Ishii2001-09-093-94/+211
|
* To fix the perpetually broken makefiles in the contrib tree, I havePeter Eisentraut2001-09-061-28/+6
| | | | | | written a generic framework of rules that the contrib makefiles can use instead of writing their own each time. You only need to set a few variables and off you go.
* When invoked with -i (initialize mode), split the copy command everyTatsuo Ishii2001-08-011-22/+45
| | | | | 10000 tuples, rather than one big copy. This will prevent generating too much WAL logs.
* Make sure -L and -I's for our source tree are always before system includePeter Eisentraut2001-02-201-3/+3
| | | | or library directories on the command line.
* Fix README in Japanese to sync with README.pgbench updated by Tom.Tatsuo Ishii2001-02-171-6/+9
| | | | (thanks!)
* Update README's install instructions to agree with current reality.Tom Lane2001-02-161-9/+10
|
* Restructure the key include files per recent pghackers discussion: thereTom Lane2001-02-101-5/+2
| | | | | | | | | | | are now separate files "postgres.h" and "postgres_fe.h", which are meant to be the primary include files for backend .c files and frontend .c files respectively. By default, only include files meant for frontend use are installed into the installation include directory. There is a new make target 'make install-all-headers' that adds the whole content of the src/include tree to the installed fileset, for use by people who want to develop server-side code without keeping the complete source tree on hand. Cleaned up a whole lot of crufty and inconsistent header inclusions.
* Fix bogus makefiles ... these didn't build on platforms that are stickyREL7_1_BETATom Lane2000-12-041-3/+14
| | | | about being given accurate references to referenced libraries ...
* Fix for PQsetdb port parameter due to the interface change.Tatsuo Ishii2000-11-011-3/+3
| | | | PQsetdb no more recognize "" as the default port number.
* Add support for VPATH builds, that is, building somewhere else than in thePeter Eisentraut2000-10-201-4/+4
| | | | | | | | | source directory. This involves mostly makefiles using $(srcdir) when they might have used ".". (Regression tests don't work with this, yet.) Sort out usage of CPPFLAGS, CFLAGS (and CXXFLAGS). Add "override" keyword in most places, to preserve necessary flags even when the user overrode the flags.
* Standardize on __CYGWIN__ rather than __CYGWIN32__ macro. Doesn't matterPeter Eisentraut2000-09-291-4/+4
| | | | | either way (although the former is preferred by the Cygwin folks themselves), but using only one seems nicer.
* Fix relative path references so that make knowns which dependencies referPeter Eisentraut2000-08-311-3/+3
| | | | | to one another. Sort out builddir vs srcdir variable namings. Remove some now obsoleted make variables.
* Remove a bunch of unused configure tests, in particular cases wherePeter Eisentraut2000-07-121-3/+1
| | | | | | | | | | * the result is not recorded anywhere * the result is not used anywhere * the result is only used in some places, whereas others have been getting away with it * the result is used improperly Also make command line options handling a little better (e.g., --disable-locale, while redundant, should really still *dis*able).
* Another round of those unportable config/build changes :-/Peter Eisentraut2000-07-091-39/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Add option to build with OpenSSL out of the box. Fix thusly exposed bit rot. Although it compiles now, getting this to do something useful is left as an exercise. * Fix Kerberos options to defer checking for required libraries until all the other libraries are checked for. * Change default odbcinst.ini and krb5.srvtab path to PREFIX/etc. * Install work around for Autoconf's install-sh relative path anomaly. Get rid of old INSTL_*_OPTS variables, now that we don't need them anymore. * Use `gunzip -c' instead of g?zcat. Reportedly broke on AIX. * Look for only one of readline.h or readline/readline.h, not both. * Make check for PS_STRINGS cacheable. Don't test for the header files separately. * Disable fcntl(F_SETLK) test on Linux. * Substitute the standard GCC warnings set into CFLAGS in configure, don't add it on in Makefile.global. * Sweep through contrib tree to teach makefiles standard semantics. ... and in completely unrelated news: * Make postmaster.opts arbitrary options-aware. I still think we need to save the environment as well.
* Very small changes in the contrib's pg_dumplo in the attache.Bruce Momjian2000-07-031-0/+0
| | | | | | | | | | | | | | | | | And: Note, Bruce I found in the contrib tree any files that we forget remove during contrib cleaning. Please remove these files: contrib/lo/test.sql contrib/pg_dumplo/Makefile.out contrib/pgbench/pgbench_jis.doc contrib/spi/new_example.example contrib/spi/README.MAX Thanks. Karel
* Remove old README files.Bruce Momjian2000-06-191-0/+0
|
* Add missing /contrib filesBruce Momjian2000-06-192-0/+315
|
* Update to /contrib from Karel.Bruce Momjian2000-06-194-318/+3
|
* Cleanup README Makefile installs.Bruce Momjian2000-06-161-3/+3
|
* Add missing /contrib files to CVS.Bruce Momjian2000-06-151-0/+166
|
* /contrib patch from Karel.Bruce Momjian2000-06-152-179/+38
|
* Generated header files parse.h and fmgroids.h are now copied intoTom Lane2000-05-291-2/+2
| | | | | the src/include tree, so that -I backend is no longer necessary anywhere. Also, clean up some bit rot in contrib tree.
* Ye-old pgindent run. Same 4-space tabs.Bruce Momjian2000-04-121-640/+723
|
* Modify pgbench.c not to depend on configure, since it's not shipped with one.Tom Lane2000-04-081-2/+2
|
* Add pgench: a TPC-B like benchmarking toolTatsuo Ishii2000-01-154-0/+1075