Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 29EAB650044 for ; Sun, 6 Jul 2008 02:53:59 -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 87981-05 for ; Sun, 6 Jul 2008 02:53:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EEB5C64FD34 for ; Sun, 6 Jul 2008 02:53:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m665rKKL023935; Sun, 6 Jul 2008 01:53:20 -0400 (EDT) To: Simon Riggs cc: Russell Smith , List pgsql-patches Subject: Re: pgbench minor fixes In-reply-to: <1215272700.4051.301.camel@ebony.site> References: <1215263027.4051.299.camel@ebony.site> <486F7FCF.7030606@pws.com.au> <1215272700.4051.301.camel@ebony.site> Comments: In-reply-to Simon Riggs message dated "Sat, 05 Jul 2008 16:45:00 +0100" Date: Sun, 06 Jul 2008 01:53:20 -0400 Message-ID: <23934.1215323600@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/94 X-Sequence-Number: 6788 Simon Riggs writes: > On Sun, 2008-07-06 at 00:06 +1000, Russell Smith wrote: >> Simon Riggs wrote: >>> 1. -i option should run vacuum analyze only on pgbench tables, not *all* >>> tables in database. > >> How does this work with custom scripts? > I don't think we can justify vacuuming every table in the database just > so we get any tables being used for one set of tests. Actually your point is that the -i option wouldn't be used anyway with a custom script ... regards, tom lane