X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5CD819DD44A for ; Thu, 1 Dec 2005 09:34:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87473-02 for ; Thu, 1 Dec 2005 09:34:35 -0400 (AST) X-Greylist: delayed 01:00:00.46202 by SQLgrey- Received: from nt-home.ipworldcom.ch (unknown [212.74.134.180]) by postgresql.org (Postfix) with ESMTP id 661BE9DCAB5 for ; Thu, 1 Dec 2005 09:34:37 -0400 (AST) Received: from [212.74.168.29] (account wgehner@infonoia.ch HELO [10.0.1.112]) by nt-home.ipworldcom.ch (CommuniGate Pro SMTP 4.3.6) with ESMTPA id 17561328; Thu, 01 Dec 2005 13:34:38 +0100 Message-ID: <438EED91.9080302@infonoia.com> Date: Thu, 01 Dec 2005 13:33:21 +0100 From: Wolfgang Gehner User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: slow insert into very large table Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/7 X-Sequence-Number: 15828 Hi there, I need a simple but large table with several million records. I do batch inserts with JDBC. After the first million or so records, the inserts degrade to become VERY slow (like 8 minutes vs initially 20 secondes). The table has no indices except PK while I do the inserts. This is with PostgreSQL 8.0 final for WindowsXP on a Pentium 1.86 GHz, 1GB Memory. HD is fast IDE. I already have shared buffers already set to 25000. I wonder what else I can do. Any ideas? Kindest regards, Wolfgang Gehner -- Infonoia SA 7 rue de Berne 1211 Geneva 1 Tel: +41 22 9000 009 Fax: +41 22 9000 018 http://www.infonoia.com