Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C4CBE650060
	for <pgsql-patches-postgresql.org@postgresql.org>;
	Sat,  5 Jul 2008 11:06:34 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 37709-03 for
	<pgsql-patches-postgresql.org@postgresql.org>;
	Sat,  5 Jul 2008 11:06:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.trinitydigital.com.au (mail.trinitydigital.com.au
	[122.102.101.9])
	by postgresql.org (Postfix) with ESMTP id 2CB4D64FD42
	for <pgsql-patches@postgresql.org>;
	Sat,  5 Jul 2008 11:06:29 -0300 (ADT)
Received: from localhost (unknown [122.102.101.11])
	by mail.trinitydigital.com.au (Postfix) with ESMTP id 5DE2E2A649;
	Sun,  6 Jul 2008 00:05:19 +1000 (EST)
Received: from mail.trinitydigital.com.au ([122.102.101.9])
	by localhost (spam-filter.trinitydigital.com.au [122.102.101.11])
	(amavisd-new, port 10024)
	with LMTP id 00817-01-35; Sun, 6 Jul 2008 00:05:35 +1000 (EST)
Received: from [172.17.73.17] (ppp59-167-146-4.lns4.mel6.internode.on.net
	[59.167.146.4])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.trinitydigital.com.au (Postfix) with ESMTP id 53FB32A640;
	Sun,  6 Jul 2008 00:05:05 +1000 (EST)
Message-ID: <486F7FCF.7030606@pws.com.au>
Date: Sun, 06 Jul 2008 00:06:07 +1000
From: Russell Smith <mr-russ@pws.com.au>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.8.1.14) Gecko/20080505 Thunderbird/2.0.0.14 Mnenhy/0.7.5.0
MIME-Version: 1.0
To: Simon Riggs <simon@2ndquadrant.com>
CC: List pgsql-patches <pgsql-patches@postgresql.org>
Subject: Re: pgbench minor fixes
References: <1215263027.4051.299.camel@ebony.site>
In-Reply-To: <1215263027.4051.299.camel@ebony.site>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Trinity Digital Spam Filter
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.021 tagged_above=0 required=5 tests=AWL=0.021
X-Spam-Level: 
X-Archive-Number: 200807/83
X-Sequence-Number: 6777

Simon Riggs wrote:
> Minor patch on pgbench
>
> 1. -i option should run vacuum analyze only on pgbench tables, not *all*
> tables in database.
>   
How does this work with custom scripts?
> 2. pre-run cleanup step was DELETE FROM HISTORY then VACUUM HISTORY.
> This is just a slow version of TRUNCATE HISTORY.
>
>