Received: from web14706.mail.yahoo.com (web14706.mail.yahoo.com [216.136.224.123]) by postgresql.org (Postfix) with SMTP id 1D165475850 for ; Fri, 26 Jul 2002 15:15:06 -0400 (EDT) Message-ID: <20020726191506.98245.qmail@web14706.mail.yahoo.com> Received: from [130.221.203.117] by web14706.mail.yahoo.com via HTTP; Fri, 26 Jul 2002 12:15:06 PDT Date: Fri, 26 Jul 2002 12:15:06 -0700 (PDT) From: Chris Albertson Subject: Re: 1 milion data insertion To: Elielson Fontanezi , pgsql-general Cc: pgsql-sql In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200207/1663 X-Sequence-Number: 28150 > > Ok, this was a test. I'd like to know what would be happen. > But, from you, great PostGres DBA's, what is the best way to > insert a large number of data? > Is there a way to turn off the log? > Is there a way to commit each 100 records? Yes, "COPY" actually does an append. So just do what you do now 10,000 times for 100 records. It's a bit safer. I've done 1M recod COPYsmany times on a low-end PC, no trouble Put the log file someplace with more room. You should be able to run for a month without worrying about log files over filling Logging is controled likely from the startup script. Maybe in /etc/rc.d details depend on your OS. ===== Chris Albertson Home: 310-376-1029 chrisalbertson90278@yahoo.com Cell: 310-990-7550 Office: 310-336-5189 Christopher.J.Albertson@aero.org __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com