Re: COPY FROM performance improvements

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Alon Goldshuv <agoldshuv(at)greenplum(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY FROM performance improvements
Date: 2005-08-10 16:56:00
Message-ID: 42FA31A0.1040503@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> Also, as we proved the last time the correctness argument was thrown in, we
> can fix the bugs and still make it a lot faster - and I would stick to that
> whether it's a PA-RISC, DEC Alpha, Intel or AMD or event Ultra Sparc.

Luke this comment doesn't work. Do you have a test case that shows that
on an Ultra Sparc or PPC that you are accurate? Both of these CPUs are
pretty big players in the Enterprise space.

> PostgreSQL needs major improvement to compete with Oracle and even MySQL on
> speed. No whacking on the head is going to change that.

I am going to assume that you forgot to clarify this statement with "IN
BULK LOADING", because if you didn't I would like to see your test results.

My very real life experience shows that MySQL can't not keep up with
PostgreSQL under load.

Nobody here argues that PostgreSQL needs to improve. If it didn't need
to improve I would be out of business because it would be perfect.

Sincerely,

Joshua D. Drake

>
> - Luke
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-08-10 16:57:18 Re: COPY FROM performance improvements
Previous Message Bruce Momjian 2005-08-10 16:54:46 Re: COPY FROM performance improvements