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

From Tatsuo Ishii
Subject Re: Optimized pgbench for 8.3
Date
Msg-id 20070406.215949.45965181.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Optimized pgbench for 8.3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-patches
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.
>
> 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

pgsql-patches by date:

Previous
From: Zdenek Kotala
Date:
Subject: Fix for large file support
Next
From: Andrew Dunstan
Date:
Subject: Re: Fix for large file support