|
1 | 1 | /* |
2 | | - * $PostgreSQL: pgsql/contrib/pgbench/pgbench.c,v 1.76 2008/03/10 01:23:04 tgl Exp $ |
| 2 | + * $PostgreSQL: pgsql/contrib/pgbench/pgbench.c,v 1.77 2008/03/12 02:18:33 tgl Exp $ |
3 | 3 | * |
4 | 4 | * pgbench: a simple benchmark program for PostgreSQL |
5 | 5 | * written by Tatsuo Ishii |
@@ -811,6 +811,16 @@ init(void) |
811 | 811 | { |
812 | 812 | PGconn*con; |
813 | 813 | PGresult*res; |
| 814 | +/* |
| 815 | + * Note: TPC-B requires at least 100 bytes per row, and the "filler" |
| 816 | + * fields in these table declarations were intended to comply with that. |
| 817 | + * But because they default to NULLs, they don't actually take any |
| 818 | + * space. We could fix that by giving them non-null default values. |
| 819 | + * However, that would completely break comparability of pgbench |
| 820 | + * results with prior versions. Since pgbench has never pretended |
| 821 | + * to be fully TPC-B compliant anyway, we stick with the historical |
| 822 | + * behavior. |
| 823 | + */ |
814 | 824 | staticchar*DDLs[]= { |
815 | 825 | "drop table if exists branches", |
816 | 826 | "create table branches(bid int not null,bbalance int,filler char(88)) with (fillfactor=%d)", |
|