| From: | ishii(at)postgresql(dot)org (Tatsuo Ishii) | 
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org | 
| Subject: | pgsql: Various pgbench enhancements. | 
| Date: | 2007-04-06 08:49:44 | 
| Message-ID: | [email protected] | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-committers | 
Log Message:
-----------
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!
--------------------------------------------------------------------------
Modified Files:
--------------
    pgsql/contrib/pgbench:
        README.pgbench (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/README.pgbench.diff?r1=1.15&r2=1.16)
        README.pgbench_jis (r1.16 -> r1.17)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/README.pgbench_jis.diff?r1=1.16&r2=1.17)
        pgbench.c (r1.62 -> r1.63)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/pgbench.c.diff?r1=1.62&r2=1.63)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2007-04-06 09:16:16 | pgsql: Enhance pgbench -l option to add timestamp. | 
| Previous Message | Tom Lane | 2007-04-06 05:36:51 | pgsql: Now that core functionality is depending on autoconf's |