From: Steve Atkins <steve@blighty.com>
To: pgsql-general@postgresql.org
Subject: Re: Performance issues with compaq server
Date: Wed, 8 May 2002 10:53:08 -0700
Message-ID: <20020508105308.A14127@blighty.com> (raw)
In-Reply-To: <m3offqk7hw.fsf@varsoon.wireboard.com>
References: <Pine.LNX.4.44.0205080903080.11632-100000@bluebell.marzen.de>
<m3offqk7hw.fsf@varsoon.wireboard.com>
On Wed, May 08, 2002 at 11:02:35AM -0400, Doug McNaught wrote:
> 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.
Does anyone have any performance figures to hand on COPY vs BEGIN/INSERT/END,
on indexed or unindexed tables?
Cheers,
Steve
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: steve@blighty.com, pgsql-general@postgresql.org
Subject: Re: Performance issues with compaq server
In-Reply-To: <20020508105308.A14127@blighty.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