From: Luke Lonergan <llonergan@greenplum.com>
To: Markus Schaber <schabi@logix-tt.com>
To: Worky Workerson <worky.workerson@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best COPY Performance
Date: Mon, 23 Oct 2006 08:11:00 -0700
Message-ID: <C1622994.4E77%llonergan@greenplum.com> (raw)
In-Reply-To: <453C8B0D.4070803@logix-tt.com>
Markus,
On 10/23/06 2:27 AM, "Markus Schaber" <schabi@logix-tt.com> wrote:
> On a table with no indices, triggers and contstraints, we managed to
> COPY about 7-8 megabytes/second with psql over our 100 MBit network, so
> here the network was the bottleneck.
We routinely get 10-12MB/s on I/O hardware that can sustain a sequential
write rate of 60+ MB/s with the WAL and data on the same disks.
It depends on a few things you might not consider, including the number and
type of columns in the table and the client and server encoding. The
fastest results are with more columns in a table and when the client and
server encoding are the same.
- Luke
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: llonergan@greenplum.com, schabi@logix-tt.com, worky.workerson@gmail.com
Subject: Re: Best COPY Performance
In-Reply-To: <C1622994.4E77%llonergan@greenplum.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