Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 83D279FB2AA
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 27 Oct 2006 15:40:29 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 69653-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 27 Oct 2006 18:40:09 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nz-out-0102.google.com (nz-out-0102.google.com
 [64.233.162.197])
	by postgresql.org (Postfix) with ESMTP id C59B89FA089
	for <pgsql-performance@postgresql.org>;
	Fri, 27 Oct 2006 15:39:59 -0300 (ADT)
Received: by nz-out-0102.google.com with SMTP id i11so643655nzi
	for <pgsql-performance@postgresql.org>;
	Fri, 27 Oct 2006 11:39:58 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=iDjgawJtnOJfHhkdYg2tOmAJpKr9pV74bj+4Yf/r8oQ/zeWm6586Zs3+Vf0KndFbbCbkOVgNKpzitRLK5FaxmC7DYQHz9UNFFfGfJUEpkBXI2jlFStA8WDvSYapiHTQHnlQ1seCAqUJPgsNHw5Me10Sn8mK+UNRrel04QcjY9PM=
Received: by 10.35.89.10 with SMTP id r10mr692716pyl;
	Fri, 27 Oct 2006 11:39:58 -0700 (PDT)
Received: by 10.35.49.10 with HTTP; Fri, 27 Oct 2006 11:39:57 -0700 (PDT)
Message-ID: <ce4072df0610271139l4b499fc7s55487e4c621ca949@mail.gmail.com>
Date: Fri, 27 Oct 2006 14:39:57 -0400
From: "Worky Workerson" <worky.workerson@gmail.com>
To: "Luke Lonergan" <llonergan@greenplum.com>
Subject: Re: Best COPY Performance
Cc: pgsql-performance@postgresql.org
In-Reply-To: <C1651375.523A%llonergan@greenplum.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <ce4072df0610251126w1eaca026x7751256f962b131f@mail.gmail.com>
	<C1651375.523A%llonergan@greenplum.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.199 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200610/584
X-Sequence-Number: 21713

I do have a dirty little secret, one which I wasn't completely aware
of until a little while ago.  Apparently, someone decided to install
Oracle on the server, and use the SAN as the primary tablespace, so
that might have something to do with the poor performance of the SAN.
At least, I'm hoping that's what is involved.  I'll be able to tell
for sure when I can rerun the benchmarks on Monday without Oracle.

Thank you all for all your help so far.  I've learned a ton about
Postgres (and life!) from both this thread and this list in general,
and the "support" has been nothing less than spectacular.

I'm hoping that the corporate Oracle machine won't shut down my pg
projects.  On total side note, if anyone knows how to best limit
Oracle's impact on a system (i.e. memory usage, etc), I'd be
interested.

I hate shared DB servers.

Thanks!