From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Nolan <nolan@gw.tssi.com>
Cc: scrappy@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Sustained inserts per sec ... ?
Date: Fri, 01 Apr 2005 16:03:37 -0500
Message-ID: <28575.1112389417@sss.pgh.pa.us> (raw)
In-Reply-To: <200504011927.j31JRFMK006424@gw.tssi.com>
References: <200504011927.j31JRFMK006424@gw.tssi.com>
Mike Nolan <nolan@gw.tssi.com> writes:
> Well, I just did an insert of 27,500 records with 9 fields, averaging
> around 118 bytes per record, each insert statement coming from a separate
> SQL statement fed to psql, and it took a bit over 4 minutes, or about
> 106 inserts per second.
Is that with a separate transaction for each insert command? I can get
significantly higher rates on my devel machine if the inserts are
bundled into transactions of reasonable length.
With fsync on, you can't expect to get more than about one commit per
disk rotation (with a single inserting process), so with say a 7200RPM
drive (120 revs/sec) the above is a pretty good fraction of the
theoretical limit.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, nolan@gw.tssi.com, scrappy@postgresql.org
Subject: Re: Sustained inserts per sec ... ?
In-Reply-To: <28575.1112389417@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox