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 26D525E46DF for ; Fri, 13 Aug 2004 07:08:12 -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 08651-09 for ; Fri, 13 Aug 2004 10:08:04 +0000 (GMT) Received: from honorio.sinectis.com.ar (honorio.sinectis.com.ar [216.244.192.201]) by svr1.postgresql.org (Postfix) with ESMTP id 1B35E5E37D0 for ; Fri, 13 Aug 2004 07:08:00 -0300 (ADT) Received: by honorio.sinectis.com.ar (Postfix, from userid 99) id 24FC86C37F; Fri, 13 Aug 2004 07:08:00 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.5.1 From: G u i d o B a r o s i o To: ulrich.wisser@relevanttraffic.se, pgsql-performance@postgresql.org Subject: Re: insert Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20040813100800.24FC86C37F@honorio.sinectis.com.ar> Date: Fri, 13 Aug 2004 07:08:00 -0300 (GMT+3) 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/197 X-Sequence-Number: 7833 Tips! *Delete indexes and recreate them after the insert. *Disable auto-commit *Perform a copy will be faster, sure. Best wishes, Guido > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match