Re: Benchmark Data requested

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>
Subject: Re: Benchmark Data requested
Date: 2008-02-06 17:31:48
Message-ID: 200802061831.50525.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Le mercredi 06 février 2008, Greg Smith a écrit :
> COPY. If you're loading a TB, if you're smart it's going onto the server
> itself if it all possible and loading directly from there. Would probably
> get a closer comparision against psql \copy, but recognize you're always
> going to be compared against the best server-side copy method available.

Fair enough on your side, even if I can't expect an external tool using
network protocol to compete with backend reading a local file. I wanted to
make sure the 50% slowdown was not only due to my code being that bad.

> There are way too many data massaging cases I never expect the backend
> will handle that pgloader does a great job of right now, and I think there
> will always be a niche for a tool like this.

Let's try to continue improving the tool then!
--
dim

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2008-02-06 17:37:41 Re: Benchmark Data requested --- pgloader CE design ideas
Previous Message Jignesh K. Shah 2008-02-06 16:34:14 Re: Benchmark Data requested --- pgloader CE design ideas