pgbench support dynamic identifier name - Mailing list pgsql-general

From 德哥
Subject pgbench support dynamic identifier name
Date
Msg-id 3a284a5c.c29d.1581f486ca5.Coremail.digoal@126.com
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Adam Carrgilson
Date:
Subject: Postgres create database freezes - trying to run with replication
Next
From: Francisco Olarte
Date:
Subject: Re: Turning slave into a master - PostgreSQL 9.2