Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B74EF9FB1F7 for ; Sat, 28 Oct 2006 00:43:57 -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 75987-08 for ; Sat, 28 Oct 2006 03:43:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 35F869FB1E2 for ; Sat, 28 Oct 2006 00:43:26 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id i11so746057nzi for ; Fri, 27 Oct 2006 20:43:25 -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=Jb2wsG2ixXzb2Y4qZxl3FIvKMZ5+nrphFut7Dc6dDwBWAzJyOiifSFfF6fcy/ZrhUSAH4d8RmnrrAlymhIxCIaxEN05wHglrtvQ/fUZN+dtkW15nBHN8qROGkT+9hK9I9VVBDnAkjIY0Fh36Gz/CFwOQ/8JI45n/eZ8NM7EqP9w= Received: by 10.35.103.1 with SMTP id f1mr686682pym; Fri, 27 Oct 2006 20:43:25 -0700 (PDT) Received: by 10.35.49.10 with HTTP; Fri, 27 Oct 2006 20:43:25 -0700 (PDT) Message-ID: Date: Fri, 27 Oct 2006 23:43:25 -0400 From: "Worky Workerson" To: "Luke Lonergan" Subject: Re: Best COPY Performance Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: 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/590 X-Sequence-Number: 21719 > 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.