Re: insert performance

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(dot)janes(at)gmail(dot)com>:
> On Sat, Jan 9, 2016 at 9:57 PM, Jinhua Luo <luajit(dot)io(at)gmail(dot)com> 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