On Tue, 2007-09-25 at 22:16 +0530, Pavan Deolasee wrote: > The only problem I faced is while executing custom scripts using > pgbench. > You either need to do the initialization (pgbench -i) or run with -n > option > (no vacuum). But I don't have any strong preference here.
Yes, I had that problem too. pgbench allows you to run a script file, but there is no way to run an initialiser script for a custom workload. Worse, if you don't do -n when you run a custom script, it tells you that the branches table doesn't exist, which is strange if you aren't using that in your scripts. Proposed enhancement to pgbench: -g filename runs filename prior to start of main test transactions. Only used in conjunction with the -f option. Normal cleaning/vacuuming of TPC-B tables does not occur if -g option set. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster