From: Artimenko Igor <igorart7@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Copy command freezes but INSERT works fine with trigger on insert.
Date: Fri, 27 Aug 2004 13:53:38 -0700 (PDT)
Message-ID: <20040827205338.55219.qmail@web11908.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: igorart7@yahoo.com
Subject: Re: Copy command freezes but INSERT works fine with trigger on insert.
In-Reply-To: <20040827205338.55219.qmail@web11908.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox