From: Worky Workerson <worky.workerson@gmail.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best COPY Performance
Date: Fri, 27 Oct 2006 14:39:57 -0400
Message-ID: <ce4072df0610271139l4b499fc7s55487e4c621ca949@mail.gmail.com> (raw)
In-Reply-To: <C1651375.523A%llonergan@greenplum.com>
References: <ce4072df0610251126w1eaca026x7751256f962b131f@mail.gmail.com>
<C1651375.523A%llonergan@greenplum.com>
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!
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: worky.workerson@gmail.com, llonergan@greenplum.com
Subject: Re: Best COPY Performance
In-Reply-To: <ce4072df0610271139l4b499fc7s55487e4c621ca949@mail.gmail.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