Received: from web802.mail.yahoo.com (web802.mail.yahoo.com [128.11.23.62]) by hub.org (8.10.1/8.10.1) with SMTP id e7U04aC01978 for ; Tue, 29 Aug 2000 20:04:36 -0400 (EDT) Received: (qmail 2111 invoked by uid 60001); 30 Aug 2000 00:04:52 -0000 Message-ID: <20000830000452.2110.qmail@web802.mail.yahoo.com> Received: from [63.169.132.205] by web802.mail.yahoo.com; Tue, 29 Aug 2000 17:04:52 PDT Date: Tue, 29 Aug 2000 17:04:52 -0700 (PDT) From: Webb Sprague Subject: Optimizing huge inserts/copy's To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200008/331 Hi all, Does anybody have any thoughts on optimizing a huge insert, involving something like 3 million records all at once? Should I drop my indices before doing the copy, and then create them after? I keep a tab-delimited file as a buffer, copy it, then do it again about 400 times. Each separate buffer is a few thousand records. We do this at night, so it's not the end of the world if it takes 8 hours, but I would be very grateful for some good ideas... Thanks W __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/