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: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches

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 

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.


Attachment: pg_dump.c.diff.gz
Description: application/x-gzip (1.1 KB)


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-2017 The PostgreSQL Global Development Group