pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Wampler <swampler@noao.edu>
To: Mohan, Ross <RMohan@arbinet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: RE : RE: Postgresql vs SQLserver for this application
Date: Wed, 06 Apr 2005 09:38:51 -0700
Message-ID: <4254109B.5090809@noao.edu> (raw)
In-Reply-To: <CC74E7E10A8A054798B6611BD1FEF4D30625DA34@vamail01.thexchange.com>
References: <CC74E7E10A8A054798B6611BD1FEF4D30625DA34@vamail01.thexchange.com>

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.



view thread (5+ messages)  latest in thread

Message-ID: <4254109B.5090809@noao.edu>
Permalink:  ../4254109B.5090809@noao.edu/
Also on:    postgresql.org/message-id/4254109B.5090809@noao.edu

 · 

reply

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: swampler@noao.edu, RMohan@arbinet.com
  Subject: Re: RE : RE: Postgresql vs SQLserver for this application
  In-Reply-To: <4254109B.5090809@noao.edu>

* 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