X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C056A53245 for ; Wed, 6 Apr 2005 17:39:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17453-05 for ; Wed, 6 Apr 2005 16:39:01 +0000 (GMT) Received: from noao.edu (noao.edu [140.252.1.54]) by svr1.postgresql.org (Postfix) with ESMTP id 06F1A53502 for ; Wed, 6 Apr 2005 17:39:00 +0100 (BST) X-TFF-CGPSA-Version: 1.4f1 X-TFF-CGPSA-Filter: Scanned Received: from [140.252.14.8] (HELO weaver.tuc.noao.edu) by noao.edu (CommuniGate Pro SMTP 4.2.10) with ESMTP-TLS id 17541340; Wed, 06 Apr 2005 09:38:53 -0700 Received: from [127.0.0.1] (localhost.localdomain [127.0.0.1]) by weaver.tuc.noao.edu (8.12.8/8.12.8) with ESMTP id j36GcpKv028119; Wed, 6 Apr 2005 09:38:51 -0700 Message-ID: <4254109B.5090809@noao.edu> Date: Wed, 06 Apr 2005 09:38:51 -0700 From: Steve Wampler User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Mohan, Ross" Cc: pgsql-performance@postgresql.org Subject: Re: RE : RE: Postgresql vs SQLserver for this application References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-noao.edu-MailScanner-Information: Please contact the ISP for more information X-noao.edu-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/100 X-Sequence-Number: 11497 Mohan, Ross wrote: > I wish I had a Dell system and run case to show you Alex, but I don't... > however...using Oracle's "direct path" feature, it's pretty straightforward. > > We've done 110,000 rows per second into index-less tables on a big system > (IBM Power5 chips, Hitachi SAN). ( Yes, I am sure: over 100K a second. Sustained > for almost 9 minutes. ) > > Yes, this is an exception, but oracle directpath/InsertAppend/BulkLoad > feature enabled us to migrate a 4 TB database...really quickly. How close to this is PG's COPY? I get surprisingly good results using COPY with jdbc on smallish systems (now if that patch would make into the mainstream PG jdbc support!) I think COPY has a bit more overhead than what a Bulkload feature may have, but I suspect it's not that much more. > Now...if you ask me "can this work without Power5 and Hitachi SAN?" > my answer is..you give me a top end Dell and SCSI III on 15K disks > and I'll likely easily match it, yea. > > I'd love to see PG get into this range..i am a big fan of PG (just a > rank newbie) but I gotta think the underlying code to do this has > to be not-too-complex..... It may not be that far off if you can use COPY instead of INSERT. But comparing Bulkload to INSERT is a bit apples<->orangish. -- Steve Wampler -- swampler@noao.edu The gods that smiled on your birth are now laughing out loud.