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 910569DD6A4 for ; Thu, 1 Dec 2005 11:50:16 -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 48553-02 for ; Thu, 1 Dec 2005 11:50:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ECC8A9DD694 for ; Thu, 1 Dec 2005 11:50:11 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jB1FoEdm011196; Thu, 1 Dec 2005 10:50:14 -0500 (EST) To: Wolfgang Gehner cc: pgsql-performance@postgresql.org Subject: Re: slow insert into very large table In-reply-to: <438EED91.9080302@infonoia.com> References: <438EED91.9080302@infonoia.com> Comments: In-reply-to Wolfgang Gehner message dated "Thu, 01 Dec 2005 13:33:21 +0100" Date: Thu, 01 Dec 2005 10:50:14 -0500 Message-ID: <11195.1133452214@sss.pgh.pa.us> From: Tom Lane 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/17 X-Sequence-Number: 15838 Wolfgang Gehner writes: > This is with PostgreSQL 8.0 final for WindowsXP on a Pentium 1.86 GHz, > 1GB Memory. HD is fast IDE. Try something more recent, like 8.0.3 or 8.0.4. IIRC we had some performance issues in 8.0.0 with tables that grew from zero to large size during a single session. regards, tom lane