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

From Bruce Momjian
Subject Re: Optimized pgbench for 8.3
Date
Msg-id 200703250144.l2P1il206064@momjian.us
Whole thread Raw
In response to Optimized pgbench for 8.3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-patches
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.

---------------------------------------------------------------------------


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: Bruce Momjian
Date:
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages
Next
From: Bruce Momjian
Date:
Subject: Re: POSIX Shared memory, revised, again