pg_dump and transactions - Mailing list pgsql-patches

From Ferdinand Smit
Subject pg_dump and transactions
Date
Msg-id 200203211033.g2LAXn917715@server9.telegraafnet.nl
Whole thread Raw
Responses Re: pg_dump and transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_dump and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Hi,

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.

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

I hope you like it.
Regards,

Ferdinand

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: JDBC Connection startup cleaned up
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump and transactions