Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9D9D99FB319 for ; Mon, 23 Oct 2006 12:11:20 -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 11843-04 for ; Mon, 23 Oct 2006 15:11:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exprod6og51.obsmtp.com (exprod6og51.obsmtp.com [64.18.1.183]) by postgresql.org (Postfix) with SMTP id 02B1D9FB2A7 for ; Mon, 23 Oct 2006 12:11:15 -0300 (ADT) Received: from source ([63.240.6.44]) by exprod6ob51.postini.com ([64.18.5.12]) with SMTP; Mon, 23 Oct 2006 08:11:09 PDT Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Mon, 23 Oct 2006 11:11:03 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 23 Oct 2006 11:11:03 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.105]) with Microsoft Exchange Server HTTP-DAV ; Mon, 23 Oct 2006 15:11:02 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Mon, 23 Oct 2006 08:11:00 -0700 Subject: Re: Best COPY Performance From: "Luke Lonergan" To: "Markus Schaber" , "Worky Workerson" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Best COPY Performance Thread-Index: Acb2tXKrsRaqjGKoEdujvAAWy4o9DA== In-Reply-To: <453C8B0D.4070803@logix-tt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 23 Oct 2006 15:11:03.0173 (UTC) FILETIME=[748FC350:01C6F6B5] X-WSS-ID: 6922040D2TS1403563-02-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/476 X-Sequence-Number: 21605 Markus, On 10/23/06 2:27 AM, "Markus Schaber" wrote: > On a table with no indices, triggers and contstraints, we managed to > COPY about 7-8 megabytes/second with psql over our 100 MBit network, so > here the network was the bottleneck. We routinely get 10-12MB/s on I/O hardware that can sustain a sequential write rate of 60+ MB/s with the WAL and data on the same disks. It depends on a few things you might not consider, including the number and type of columns in the table and the client and server encoding. The fastest results are with more columns in a table and when the client and server encoding are the same. - Luke