Search Postgresql Archives

pgbench support dynamic identifier name

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux