Обсуждение: pgbench support dynamic identifier name

Поиск
Список
Период
Сортировка

pgbench support dynamic identifier name

От
德哥
Дата:

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.