Re: Best way to load test a postgresql server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shaul Dar <shauldar(at)gmail(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, Peter Sheats <psheats(at)pbpost(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Best way to load test a postgresql server
Date: 2009-06-09 13:53:30
Message-ID: 17341.1244555610@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Shaul Dar <shauldar(at)gmail(dot)com> writes:
> Have you actually run pgbench against your own schema? Can you point me to
> an example? I also had the same impression reading the documentation. But
> when I tried it with the proper flags to use my own DB and query file I got
> an error that it couldn't find one of the tables mentioned in the built-in
> test! I concluded that I cannot use any schema,

No, you just need to read the documentation. There's a switch that
prevents the default action of trying to vacuum the "standard" tables.
I think -N, but too lazy to look ...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2009-06-09 15:48:27 Re: Problems with autovacuum
Previous Message Shaul Dar 2009-06-09 12:50:10 Re: Best way to load test a postgresql server