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 23:43:25 -0400
Message-ID: <ce4072df0610272043j4e1e41e5rb0701c66d4db21bd@mail.gmail.com> (raw)
In-Reply-To: <C167F9CE.55A8%llonergan@greenplum.com>
References: <ce4072df0610271208y4621da42j380d2f92330af213@mail.gmail.com>
<C167F9CE.55A8%llonergan@greenplum.com>
> Worky (that your real name? :-)
Nope, its Mike. worky.workerson is just the email that I use for "work" :)
> How many CPUs on the machine? Can you send the result of "cat
> /proc/cpuinfo"?
Not at work at the moment, however I do have quad dual-core opterons,
like Merlin mentioned.
> Is your "cat file | psql" being done on the DBMS server or is it on the
> network?
Everything is currently being done on the same DB server. The data
that is being loaded is on the same 2-disk "RAID10" as the OS and WAL.
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: <ce4072df0610272043j4e1e41e5rb0701c66d4db21bd@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