Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 635BC650209 for ; Sat, 23 Aug 2008 17:24:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43953-01-2 for ; Sat, 23 Aug 2008 17:24:25 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id EC81665031E for ; Sat, 23 Aug 2008 16:36:09 -0300 (ADT) X-Greylist: whitelisted by SQLgrey-1.7.6 Received: from wmproxy1-g27.free.fr (wmproxy1-g27.free.fr [212.27.42.91]) by mx3.hub.org (Postfix) with ESMTP id 8726337B83E for ; Sat, 23 Aug 2008 16:35:59 -0300 (ADT) Received: from imp2-g19.priv.proxad.net (imp2-g19.priv.proxad.net [172.20.243.44]) by wmproxy1-g27.free.fr (Postfix) with ESMTP id 2437E2B078; Sat, 23 Aug 2008 21:56:33 +0200 (CEST) Received: by imp2-g19.priv.proxad.net (Postfix, from userid 33) id 7461AE97; Sat, 23 Aug 2008 21:35:34 +0200 (CEST) Received: from ([137.43.154.234]) by imp.free.fr (IMP) with HTTP for ; Sat, 23 Aug 2008 21:35:34 +0200 Message-ID: <1219520134.48b0668645ce4@imp.free.fr> Date: Sat, 23 Aug 2008 21:35:34 +0200 From: tls.wydd@free.fr To: DiezelMax Cc: pgsql-performance@postgresql.org Subject: Re: Large number of tables slow insert References: <1775c5ea0808221841u746862e3h1b721ea82fdb7794@mail.gmail.com> <48AFE6BB.6040400@nts.biz.ua> In-Reply-To: <48AFE6BB.6040400@nts.biz.ua> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.8 X-Originating-IP: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/293 X-Sequence-Number: 31174 Actually, I've got another test system with only few sensors (thus few tables) and it's working well (<10ms insert) with all the indexes. I know it's slowing down my performance but I need them to interogate the big tables (each one can reach millions rows with time) really fast. > Each INDEX create a delay on INSERT. Try to measure performance w/o any > indexes. > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > Regards Loïc