From: Doug McNaught <doug@wireboard.com>
To: holger@marzen.de
Cc: Martijn van Oosterhout <kleptog@svana.org>
Cc: Samuel J. Sutjiono <ssutjiono@wc-group.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Performance issues with compaq server
Date: 08 May 2002 11:02:35 -0400
Message-ID: <m3offqk7hw.fsf@varsoon.wireboard.com> (raw)
References: <Pine.LNX.4.44.0205080903080.11632-100000@bluebell.marzen.de>
Holger Marzen <holger@marzen.de> writes:
> ACK. On a given hardware I get about 150 inserts per second. Using a
> begin/end transaction for a group of 100 inserts speeds it up to about
> 450 inserts per second.
COPY is even faster as there is less query parsing to be done, plus
you get a transaction per COPY statement even without BEGIN/END.
> But beware: if one insert fails (duplicate key, faulty data) then you
> have to re-insert the remaining rows as single transactions, else all
> rows of the previous transaction are discarded.
Hmm don't you have to ROLLBACK and redo the whole transaction without
the offending row(s), since you can't commit while in ABORT state? Or
am I misunderstanding?
-Doug
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-sql@postgresql.org
Cc: doug@wireboard.com, holger@marzen.de, kleptog@svana.org, ssutjiono@wc-group.com, pgsql-general@postgresql.org
Subject: Re: Performance issues with compaq server
In-Reply-To: <m3offqk7hw.fsf@varsoon.wireboard.com>
* 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