YugaByte DB是否支持pgbench？

Question

当我在初始化阶段尝试运行pgbench时，遇到一个错误“This ALTER TABLE command not supported”。详情见下文：

$ pgbench -i -U postgres -d postgres -p 5433 -h 127.0.0.1  
NOTICE:  table "pgbench_branches" does not exist, skipping  
WARNING:  Storage parameter fillfactor is unsupported, ignoring  
NOTICE:  table "pgbench_tellers" does not exist, skipping  
WARNING:  Storage parameter fillfactor is unsupported, ignoring  
NOTICE:  table "pgbench_accounts" does not exist, skipping  
WARNING:  Storage parameter fillfactor is unsupported, ignoring  
NOTICE:  table "pgbench_history" does not exist, skipping  
creating tables...  
10000 tuples done.  
20000 tuples done.  
30000 tuples done.  
40000 tuples done.  
50000 tuples done.  
60000 tuples done.  
70000 tuples done.  
80000 tuples done.  
90000 tuples done.  
100000 tuples done.  
**set primary key...  
ERROR:  This ALTER TABLE command is not yet supported**.  

Answer 1

目前，在YugaByte DB中，PRIMARY KEY子句必须指定为CREATE TABLE语句的一部分，并且不能通过ALTER TABLE命令添加到事实之后。

我们最近对"pgbench“实用程序(捆绑在YugaByte DB发行版中)进行了更改，将主键指定为CREATE TABLE语句本身的一部分。

相关的问题是:提交相关的https://github.com/YugaByte/yugabyte-db/issues/1774：https://github.com/YugaByte/yugabyte-db/commit/35b79bc35eede9907d917d72e516350a4f6bd281