What is your row size? Have you checked to see what your current inserts per second are?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Tuesday, February 06, 2007 10:56 AM To: Merlin Moncure Cc: Karen Hill; pgsql-performance@postgresql.org Subject: Re: [PERFORM] How long should it take to insert 200,000 records? On Tue, 2007-02-06 at 10:40, Merlin Moncure wrote: > On 2/6/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > On Mon, 2007-02-05 at 18:35, Karen Hill wrote: > > > I have a pl/pgsql function that is inserting 200,000 records for > > > testing purposes. What is the expected time frame for this operation > > > on a pc with 1/2 a gig of ram and a 7200 RPM disk? The processor is > > > a 2ghz cpu. So far I've been sitting here for about 2 million ms > > > waiting for it to complete, and I'm not sure how many inserts postgres > > > is doing per second. > > > > That really depends. Doing 200,000 inserts as individual transactions > > will be fairly slow. Since PostgreSQL generally runs in autocommit > > mode, this means that if you didn't expressly begin a transaction, you > > are in fact inserting each row as a transaction. i.e. this: > > I think OP is doing insertion inside a pl/pgsql loop...transaction is > implied here. Yeah, I noticed that about 10 seconds after hitting send... :) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster PRIVILEGED AND CONFIDENTIAL This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:[EMAIL PROTECTED] Thank you. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
