Re: [HACKERS] [PATCHES] Optimized pgbench for 8.3

2007-04-07 Thread Tatsuo Ishii
Patch committed. Thanks. -- Tatsuo Ishii SRA OSS, Inc. Japan > On 4/6/07, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > > > > > BTW, is anybody working on enabling the fill factor to the tables used > > by pgbench? 8.3 will introduce HOT, and I think adding the feature > > will make it easier to tes

Re: [HACKERS] [PATCHES] Optimized pgbench for 8.3

2007-04-07 Thread Pavan Deolasee
On 4/6/07, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: BTW, is anybody working on enabling the fill factor to the tables used by pgbench? 8.3 will introduce HOT, and I think adding the feature will make it easier to test HOT. Please see if the attached patch looks good. It adds a new -F option w

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-06 Thread Bruce Momjian
FYI, patch applied by Tatsuo. Thanks. --- ITAGAKI Takahiro wrote: > 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 co

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-06 Thread Tatsuo Ishii
Patch committed. Thanks. -- Tatsuo Ishii SRA OSS, Inc. Japan > 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.

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-05 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > The patches look good to me. Please commit whatever you think is reasonable. > BTW, is anybody working on enabling the fill factor to the tables used > by pgbench? 8.3 will introduce HOT, and I think adding the feature > will make it easier to test HOT.

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-05 Thread Tatsuo Ishii
> > Tatsuo, would you please comment on this patch? > > Sure. I will come up with a comment by the end of this week. The patches look good to me. BTW, is anybody working on enabling the fill factor to the tables used by pgbench? 8.3 will introduce HOT, and I think adding the feature will make it

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-04 Thread Tatsuo Ishii
> Tatsuo, would you please comment on this patch? Sure. I will come up with a comment by the end of this week. -- Tatsuo Ishii SRA OSS, Inc. Japan > --- > > ITAGAKI Takahiro wrote: > > The attached is a patch to optimize con

Re: [PATCHES] Optimized pgbench for 8.3

2007-04-04 Thread Bruce Momjian
Tatsuo, would you please comment on this patch? --- ITAGAKI Takahiro wrote: > The attached is a patch to optimize contrib/pgbench using new 8.3 features. > > - Use DROP IF EXISTS to suppress errors for initial loadings. > -

Re: [PATCHES] Optimized pgbench for 8.3

2007-03-24 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

[PATCHES] Optimized pgbench for 8.3

2007-03-04 Thread ITAGAKI Takahiro
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 opti