Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy command freezes but INSERT works fine with trigger on insert. - Mailing list pgsql-sql

From Artimenko Igor
Subject Re: Copy command freezes but INSERT works fine with trigger on insert.
Date
Msg-id 20040827205338.55219.qmail@web11908.mail.yahoo.com
Whole thread Raw
In response to Copy command freezes but INSERT works fine with trigger on insert.  (Artimenko Igor <igorart7@yahoo.com>)
List pgsql-sql
Tree view 
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:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Copy command freezes but INSERT works fine with trigger oninsert.
Next
From: Artimenko Igor
Date:
Subject: Re: [PERFORM] Why those queries do not utilize indexes?