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

From Bruce Momjian
Subject Re: Optimized pgbench for 8.3
Date
Msg-id 200704070252.l372q7r04302@momjian.us
Whole thread Raw
In response to Optimized pgbench for 8.3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-patches
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 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: Tom Lane
Date:
Subject: Re: [DOCS] Fix misleading references to columns in GRANT/REVOKE summaries
Next
From: Bruce Momjian
Date:
Subject: Re: pgbench transaction timestamps