Re: Optimized pgbench for 8.3 - Mailing list pgsql-patches

From Tatsuo Ishii
Subject Re: Optimized pgbench for 8.3
Date
Msg-id 20070405.111537.69453357.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Optimized pgbench for 8.3  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Optimized pgbench for 8.3  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-patches
> 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 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!
> >
> > Regards,
> > ---
> > ITAGAKI Takahiro
> > NTT Open Source Software Center
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
>
> --
>   Bruce Momjian  <bruce@momjian.us>          http://momjian.us
>   EnterpriseDB                               http://www.enterprisedb.com
>
>   + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: pgbench transaction timestamps
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum multiworkers, patch 5