Received: from mail.libertyrms.com (unknown [216.94.172.167]) by postgresql.org (Postfix) with ESMTP id EFF93475832 for ; Fri, 26 Jul 2002 14:46:54 -0400 (EDT) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 17YA75-0001oY-00 for ; Fri, 26 Jul 2002 14:46:55 -0400 Date: Fri, 26 Jul 2002 14:46:55 -0400 From: Andrew Sullivan To: pgsql-general Subject: Re: 1 milion data insertion Message-ID: <20020726144655.K18001@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-general References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from ElielsonF@prodam.sp.gov.br on Fri, Jul 26, 2002 at 03:34:12PM -0300 X-Archive-Number: 200207/1660 X-Sequence-Number: 28147 On Fri, Jul 26, 2002 at 03:34:12PM -0300, Elielson Fontanezi wrote: > > the log has overflowed. No, new WAL files were created. You can increase the number of preallocated WAL files so that you don't get these messages. See the administrator docs. > But, from you, great PostGres DBA's, what is the best way to > insert a large number of data? With COPY, just as you did. > Is there a way to turn off the log? No. > Is there a way to commit each 100 records? Sure. Use Perl or something to copy and commit every so many records. A ---- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada M6K 3E3 +1 416 646 3304 x110