Skip site navigation (1) Skip section navigation (2)

Re: pgbench minor fixes

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: List pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pgbench minor fixes
Date: 2008-07-05 15:45:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Sun, 2008-07-06 at 00:06 +1000, Russell Smith wrote:
> 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?

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. Not in a utility
that many users have access to, not just superusers. If you use a custom
script you just need to write a pre-test script and run it with psql.

 Simon Riggs 
 PostgreSQL Training, Services and Support

In response to


pgsql-patches by date

Next:From: Simon RiggsDate: 2008-07-05 15:46:29
Subject: Re: Explain XML patch v2
Previous:From: Tom LaneDate: 2008-07-05 15:24:12
Subject: Re: psql command setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group