CODEWITHSUNDEEP
distributed-databaseyugabytedb
Diana Garcia
Diana Garcia

Reputation: 39

Is pgbench supported for YugaByte DB?

When I tried to run pgbench, during the initialization phase, ran into an error that “This ALTER TABLE command is not yet supported.” See details below:

$ 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**.

Upvotes: 0

Views: 167

Answers (1)

Kannan Muthukkaruppan
Kannan Muthukkaruppan

Reputation: 585

In YugaByte DB, currently, the PRIMARY KEY clause has to be specified as part of the CREATE TABLE statement, and cannot be added after the fact via an ALTER TABLE command.

We have made a recent change to the "pgbench" utility (that's bundled as part of the YugaByte DB distribution) to specify the PRIMARY KEY as part of the CREATE TABLE statement itself.

The relevant issue is: https://github.com/YugaByte/yugabyte-db/issues/1774 The relevant commit: https://github.com/YugaByte/yugabyte-db/commit/35b79bc35eede9907d917d72e516350a4f6bd281

Upvotes: 2

Related Questions