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 8F7745E46C0 for ; Fri, 13 Aug 2004 08:16:53 -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 25758-02 for ; Fri, 13 Aug 2004 11:16:49 +0000 (GMT) Received: from tino.sinectis.com.ar (tino.sinectis.com.ar [216.244.192.232]) by svr1.postgresql.org (Postfix) with ESMTP id 2DE135E37D0 for ; Fri, 13 Aug 2004 08:16:46 -0300 (ADT) Received: by tino.sinectis.com.ar (Postfix, from userid 99) id 7B4116C4F8; Fri, 13 Aug 2004 08:16:49 -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: gnari@simnet.is, pgsql-performance@postgresql.org Subject: Re: insert Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20040813111649.7B4116C4F8@tino.sinectis.com.ar> Date: Fri, 13 Aug 2004 08:16:49 -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/199 X-Sequence-Number: 7835 As I see it's 100 inserts every 5 minutes, not only 100 inserts. Sure it's extreme for only 100 inserts. Cheers, Guido > "G u i d o B a r o s i o" wrote: > > [speeding up 100 inserts every 5 minutes] > > > Tips! > > *Delete indexes and recreate them after the insert. > > sounds a bit extreme, for only 100 inserts > > gnari > > > > > > ---------------------------(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