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 05AB55E46CB for ; Fri, 13 Aug 2004 04:47:29 -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 73391-04 for ; Fri, 13 Aug 2004 07:47:19 +0000 (GMT) Received: from thor.netera.se (thor.netera.se [62.13.47.20]) by svr1.postgresql.org (Postfix) with ESMTP id A0E3C5E37D0 for ; Fri, 13 Aug 2004 04:47:18 -0300 (ADT) Received: from [127.0.0.1] (unknown [213.212.22.34]) by thor.netera.se (Postfix) with ESMTP id F3BA313AC0B8 for ; Fri, 13 Aug 2004 09:47:18 +0200 (CEST) Message-ID: <411C7205.1000703@relevanttraffic.se> Date: Fri, 13 Aug 2004 09:47:17 +0200 From: Ulrich Wisser Organization: Relevant Traffic AB User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: insert Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/196 X-Sequence-Number: 7832 Hi, is there anything I can doo to speed up inserts? One of my tables gets about 100 new rows every five minutes. And somehow the inserts tend to take more and more time. Any suggestions welcome. TIA Ulrich