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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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


Browse pgsql-patches by date

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