]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Various pgbench enhancements. Patch contributed by ITAGAKI Takahiro.
authorTatsuo Ishii <ishii@postgresql.org>
Fri, 6 Apr 2007 08:49:44 +0000 (08:49 +0000)
committerTatsuo Ishii <ishii@postgresql.org>
Fri, 6 Apr 2007 08:49:44 +0000 (08:49 +0000)
commit7e96269a82d0f92db6066b1e30df5931ac1ad130
treea0b3229f04444308239b273314c89ba462186788
parent37a609b27fcb67c28ff34d02ae3e82cd9903dd13
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!
--------------------------------------------------------------------------
contrib/pgbench/README.pgbench
contrib/pgbench/README.pgbench_jis
contrib/pgbench/pgbench.c