X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6EFBCD1B4F2 for ; Fri, 14 Nov 2003 22:03:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 73031-05 for ; Fri, 14 Nov 2003 18:02:39 -0400 (AST) Received: from web80210.mail.yahoo.com (web80210.mail.yahoo.com [66.218.79.45]) by svr1.postgresql.org (Postfix) with SMTP id 737EBD1B4E4 for ; Fri, 14 Nov 2003 18:02:36 -0400 (AST) Message-ID: <20031114220238.87764.qmail@web80210.mail.yahoo.com> Received: from [199.169.240.132] by web80210.mail.yahoo.com via HTTP; Fri, 14 Nov 2003 14:02:38 PST Date: Fri, 14 Nov 2003 14:02:38 -0800 (PST) From: George Essig Subject: Re: INSERT extremely slow with large data sets (fwd) To: Slavisa Garic , pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/123 X-Sequence-Number: 4683 Slavisa Garic wrote: > Hi Everyone, > I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x > onwards) > and with all of them I noticed same problem with INSERTs when there is > a > large data set. Just to so you guys can compare time it takes to insert > one row into a table when there are only few rows present and when > there > are thousands: Try running VACUUM ANALYZE periodically during inserts. I found this to help. George Essig