Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


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 -

In response to

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group