On Wed, 6 Feb 2008, Dimitri Fontaine wrote:
Did you compare to COPY or \copy?
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.
Do you want to test pgloader again with Marko psycopgwrapper code to see if this helps?
Wouldn't have time myself for at least a month (probably not until after the East convention) so don't go making commits on my behalf.
Maybe at the end of this PostgreSQL backend code will be smarter than pgloader (wrt error handling and data massaging) and we'll be able to drop the project
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.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate