pgbench support dynamic identifier name

From: 德哥 <digoal(at)126(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pgbench support dynamic identifier name
Date: 2016-11-01 09:46:29
Message-ID: 3a284a5c.c29d.1581f486ca5.Coremail.digoal@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI,
pgbench can support literal parameter now, so if need different pgbench client thread to support different table name.
must use multi script , and set different name in the file.
but ,if pgbench can support it , will much better like sysbench.
for exp:
```
vi test.sql
\set id random(1, 10000)
\set tables 10
\set suffix :client_id % :tables
select * from test:suffix where id=:id;

it can use pgbench -M prepared to support different tablenames.
```

best regards.

--
公益是一辈子的事,I'm Digoal,Just Do It.

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-11-01 10:23:04 Re: Turning slave into a master - PostgreSQL 9.2
Previous Message Adam Carrgilson 2016-11-01 08:58:35 Postgres create database freezes - trying to run with replication