Re: pg_dump and transactions - Mailing list pgsql-patches

From Tom Lane
Subject Re: pg_dump and transactions
Date
Msg-id 27964.1016729023@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and transactions  (Ferdinand Smit <ferdinand@telegraafnet.nl>)
List pgsql-patches
Ferdinand Smit <ferdinand@telegraafnet.nl> writes:
> We have lots of trouble with using the COPY dump, so we always use de INSERT
> mode. Because the INSERT mode does'nt use transactions, this methode is very
> slow.

What would really be appreciated is some investigation into why the COPY
mode doesn't work for you.  I prefer to fix problems rather than work
around them.

> This (simple) patch creates (if the -T flag is set) a transaction of every
> insert block, so de import is mostly 10 times faster.

... kinda seems like a kluge ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: Domain Support -- another round
Next
From: Thomas Lockhart
Date:
Subject: Re: pg_dump and transactions