pg_dump and transactions

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-patches(at)postgresql(dot)org
Subject: pg_dump and transactions
Date: 2002-03-21 10:33:34
Message-ID: 200203211033.g2LAXn917715@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
pg_dump.c.diff.gz application/x-gzip 1.1 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-03-21 14:43:20 Re: pg_dump and transactions
Previous Message Bruce Momjian 2002-03-21 02:46:54 Re: [PATCHES] JDBC Connection startup cleaned up