pgbench -C -M prepared gives an error
От | Robins Tharakan |
---|---|
Тема | pgbench -C -M prepared gives an error |
Дата | |
Msg-id | CAEP4nAwqG-XufE95gpCs2dpxmV7579c3AWjgEpW=xAE7+44_cw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgbench -C -M prepared gives an error
|
Список | pgsql-bugs |
Hi, When trying pgbench with -C -M prepared gives an error (see log below). It probably doesn't make sense (to have both options together), but shouldn't it still PREPARE per connection, or exit gracefully / document this? robins@pi2:/opt/postgres/master/bin $ ./createdb pgbench robins@pi2:/opt/postgres/master/bin $ ./pgbench -i pgbench NOTICE: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping NOTICE: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping creating tables... 100000 of 100000 tuples (100%) done (elapsed 0.93 s, remaining 0.00 s) vacuum... set primary keys... done. robins@pi2:/opt/postgres/master/bin $ ./pgbench -M prepared -C pgbench starting vacuum...end. client 0 aborted in state 7: ERROR: prepared statement "P0_7" does not exist transaction type: <builtin: TPC-B (sort of)> scaling factor: 1 query mode: prepared number of clients: 1 number of threads: 1 number of transactions per client: 10 number of transactions actually processed: 1/10 latency average: 0.000 ms tps = 22.399928 (including connections establishing) tps = 52.598359 (excluding connections establishing) robins@pi2:/opt/postgres/master/bin $ ./psql -U postgres -c "select version();" version ---------------------------------------------------------------------------------------------------------- PostgreSQL 9.6devel on armv7l-unknown-linux-gnueabihf, compiled by gcc (Raspbian 4.9.2-10) 4.9.2, 32-bit (1 row) - robins -- - robins
В списке pgsql-bugs по дате отправления: