Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: pg_dump.c.diff.gz
Description: application/x-gzip (1.1 KB)

Responses

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group