X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4BBCC5281D for ; Fri, 3 Jun 2005 22:50:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52966-01 for ; Sat, 4 Jun 2005 01:50:04 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 58098528C7 for ; Fri, 3 Jun 2005 22:50:02 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 67F7030952; Sat, 4 Jun 2005 03:46:31 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Insert slow down on empty database Date: Fri, 03 Jun 2005 21:20:08 -0400 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:0ubWAGQGI9Q0NDt3tchbLJ7xRlU= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.386 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200506/82 X-Sequence-Number: 12720 In an attempt to throw the authorities off his trail, "Morgan" transmitted: > At first I was using straight insert statments, and although they > were a bit slower than the prepared statments(after the restablished > connection) they never ran into this problem with the database being > initially empty. I only changed to the prepared statements because > it was suggested in the documentation for advice on bulk data loads > =). I remember encountering this with Oracle, and the answer being "do some loading 'til it slows down, then update statistics and restart." I don't know that there's an obvious alternative outside of perhaps some variation on pg_autovacuum... -- If this was helpful, rate me http://linuxdatabases.info/info/spreadsheets.html So long and thanks for all the fish.