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

Re: Copy command freezes but INSERT works fine with trigger on insert.

From: Artimenko Igor <igorart7(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Copy command freezes but INSERT works fine with trigger on insert.
Date: 2004-08-27 20:53:38
Message-ID: 20040827205338.55219.qmail@web11908.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
Copy from .. works fine for 1000 records to load. For data set of 60000 records I could never get
it finish. And I'm planing to reload 1000,000 records.

So there is a limit somewhere between 1,000 & 60,000 since it starts working slower. The only
question for me left is. What config parameter(s) I should increase to speed up copy command and
to which values rougthly?  

Also do you know config settings to see if copy operation progresses or waits for something?


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

pgsql-sql by date

Next:From: Artimenko IgorDate: 2004-08-27 21:33:48
Subject: Re: [PERFORM] Why those queries do not utilize indexes?
Previous:From: Joe ConwayDate: 2004-08-27 20:37:57
Subject: Re: [SQL] array_in: '{}}'::text[]

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