Re: insert performance

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insert performance
Date: 2016-01-11 19:20:03
Message-ID: CAMkU=1yyyUx9ZT-TQQUf_4VZPUNck=ZhTGxLfyYQqn9CXVGz7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Skarsol 2016-01-11 19:32:21 Re: Queries getting canceled inside a proc that seems to slow down randomly
Previous Message Jim Nasby 2016-01-10 21:05:52 Re: insert performance