Hi, I found the insert performance is not related to the table schema. In fact, I could recur the issue using simple table: create table test(k bigserial primary key, a int, b int, c text, d text); test.sql: insert into test(a, b, c, d) values(3438, 1231, 'ooooooooooooooooooooooooooooooooooooo', 'kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk'); pgbench -r -N -n -c 4 -j 1 -T 600 -f test.sql I also compile and run it on the latest 9.4 version, the same issue. Regards, Jinhua Luo 2016-01-12 3:20 GMT+08:00 Jeff Janes <jeff.janes@xxxxxxxxx>: > On Sat, Jan 9, 2016 at 9:57 PM, Jinhua Luo <luajit.io@xxxxxxxxx> wrote: >> >> To make a clean test env, I clone a new table, removing the indexes (keeping >> the primary key) and triggers, and use pgbench to test insert statement >> purely. > > Can you share the pgbench command line, and the sql file you feed to > it (and whatever is needed to set up the schema)? > > > Thanks, > > Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
