Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 354ED6503E4 for ; Sat, 23 Aug 2008 17:27:40 -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 47214-04 for ; Sat, 23 Aug 2008 17:27:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id BDC1E650448 for ; Sat, 23 Aug 2008 17:15:07 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i31so426712wxd.28 for ; Sat, 23 Aug 2008 13:15:06 -0700 (PDT) Received: by 10.70.63.6 with SMTP id l6mr3266881wxa.0.1219512336204; Sat, 23 Aug 2008 10:25:36 -0700 (PDT) Received: by 10.70.22.18 with HTTP; Sat, 23 Aug 2008 10:25:36 -0700 (PDT) Message-ID: <1775c5ea0808231025u1b5df6c7nd68b1f1f264cc8b2@mail.gmail.com> Date: Sat, 23 Aug 2008 18:25:36 +0100 From: "Loic Petit" To: pgsql-performance@postgresql.org Subject: Re: Large number of tables slow insert MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_92671_25575865.1219512336341" X-Google-Sender-Auth: f12b30ba8e0056b8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/294 X-Sequence-Number: 31175 ------=_Part_92671_25575865.1219512336341 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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. Regards Lo=EFc ------=_Part_92671_25575865.1219512336341 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Actually, I've got another test system with only few s= ensors (thus few tables) and it's working well (<10ms insert) with a= ll the indexes.
I know it's slowing down my performance but I need t= hem to interogate the big tables (each one can reach millions rows with tim= e) really fast.

Regards

Lo=EFc

------=_Part_92671_25575865.1219512336341--