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.
|| S
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
From: Alex Turner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 11:38 AM
To: [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org; Mohan, Ross
Subject: Re: RE : RE: [PERFORM] Postgresql vs SQLserver for this application ?
I think everyone was scared off by the 5000 inserts per seco
I think everyone was scared off by the 5000 inserts per second number.
I've never seen even Oracle do this on a top end Dell system with
copious SCSI attached storage.
Alex Turner
netEconomist
On Apr 6, 2005 3:17 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Unfortunately.
>
> But we
Unfortunately.
But we are in the the process to choose Postgresql with pgcluster. I'm currently running some tests (performance, stability...)
Save the money on the license fees, you get it for your hardware ;-)
I still welcome any advices or comments and I'll let you know how the project is g