Re: insert performance - Mailing list pgsql-performance

From Jeff Janes
Subject Re: insert performance
Date
Msg-id CAMkU=1yyyUx9ZT-TQQUf_4VZPUNck=ZhTGxLfyYQqn9CXVGz7g@mail.gmail.com
Whole thread Raw
In response to insert performance  (Jinhua Luo <luajit.io@gmail.com>)
Responses Re: insert performance  (Jinhua Luo <luajit.io@gmail.com>)
List pgsql-performance
On Sat, Jan 9, 2016 at 9:57 PM, Jinhua Luo <luajit.io@gmail.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


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: insert performance
Next
From: Skarsol
Date:
Subject: Re: Queries getting canceled inside a proc that seems to slow down randomly