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

Re: pg_dump and transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump and transactions
Date: 2002-03-21 16:43:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
Ferdinand Smit <ferdinand(at)telegraafnet(dot)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

In response to


pgsql-patches by date

Next:From: Thomas LockhartDate: 2002-03-21 16:58:53
Subject: Re: pg_dump and transactions
Previous:From: Fernando NasserDate: 2002-03-21 16:22:57
Subject: Re: Domain Support -- another round

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