From: Luke Lonergan <llonergan@greenplum.com>
To: Michael Artz <mlartz@gmail.com>
Cc: Worky Workerson <worky.workerson@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best COPY Performance
Date: Sat, 28 Oct 2006 08:41:55 -0700
Message-ID: <C168C853.55FD%llonergan@greenplum.com> (raw)
In-Reply-To: <e9c163070610280503t4788ab5ah857ea249b5027e2@mail.gmail.com>
Michael (aka Worky),
On 10/28/06 5:03 AM, "Michael Artz" <mlartz@gmail.com> wrote:
> PG 8.1.3 x86_64. I installed it via a RH rpm for their "Web Services
> Beta", or something like that. I know I'm a bit behind the times, but
> getting stuff in (and out) of my isolated lab is a bit of a pain.
> I'll compile up a 8.2 beta as well and see how that works out.
I think 8.1 and 8.2 should be the same in this regard.
Maybe it is just the PK *build* that slows it down, but I just tried some
small scale experiments on my MacBook Pro laptop (which has the same disk
performance as your server) and I get only a 10-15% slowdown from having a
PK on an integer column. The 10-15% slowdown was on 8.1.5 MPP, so it used
both CPUs to build the index and load at about 15 MB/s.
Note that the primary key is the first column.
Table "public.part"
Column | Type | Modifiers
---------------+-----------------------+-----------
p_partkey | integer | not null
p_name | character varying(55) | not null
p_mfgr | text | not null
p_brand | text | not null
p_type | character varying(25) | not null
p_size | integer | not null
p_container | text | not null
p_retailprice | double precision | not null
p_comment | character varying(23) | not null
Indexes:
"part_pkey" PRIMARY KEY, btree (p_partkey)
What is your schema for the table?
- 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, mlartz@gmail.com, worky.workerson@gmail.com, mmoncure@gmail.com
Subject: Re: Best COPY Performance
In-Reply-To: <C168C853.55FD%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