Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C13C164FD30
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 23 Aug 2008 22:31:43 -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 02357-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 23 Aug 2008 22:31:35 -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.239])
	by postgresql.org (Postfix) with ESMTP id D328564FD20
	for <pgsql-performance@postgresql.org>;
	Sat, 23 Aug 2008 22:31:39 -0300 (ADT)
Received: by wx-out-0506.google.com with SMTP id i31so456268wxd.28
	for <pgsql-performance@postgresql.org>;
	Sat, 23 Aug 2008 18:31:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:sender
	:to:subject:cc:mime-version:content-type:x-google-sender-auth;
	bh=1iv//LyuflPwWv/UuuWWMWFfQANmIyhtniUKc04y64w=;
	b=Mt/Cmfas46LkQBZB/YXZymZ2TUD5qZ/ZsX0xeKBtLL3GAS2LeyP0MjWbb/Y8hP22vo
	BV0LToPLp7FC3ll63X6Re/A4AVr+J51ab/DyKK9REGYIpF3x5zDxl0cHPg/2AbjM03mm
	pgTkpQJZzjg0PWq1oGa/2z24IA+5gjRLfqSF4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:sender:to:subject:cc:mime-version:content-type
	:x-google-sender-auth;
	b=WYaFOp0DbthuDmNKxmpEGdslh8YJOfAfBpQcCpI16u90A0EZGTvKsh5gOTGh3pPlUp
	D+aNV1CJuIfnFEVPcVDZm9DJh9roV3CeK6UD4ill9odLoWwnscp25qbl9kxlh8tsLUNu
	FZmLIj0k073gkfX4+sOpGnLE7PiwuxjdJ5420=
Received: by 10.70.47.19 with SMTP id u19mr3769133wxu.49.1219541497601;
	Sat, 23 Aug 2008 18:31:37 -0700 (PDT)
Received: by 10.70.22.18 with HTTP; Sat, 23 Aug 2008 18:31:37 -0700 (PDT)
Message-ID: <1775c5ea0808231831m5275ff08y24ea6ef4c7479cf@mail.gmail.com>
Date: Sun, 24 Aug 2008 02:31:37 +0100
From: "Loic Petit" <tls.wydd@free.fr>
To: scott.marlowe@gmail.com
Subject: Re: Large number of tables slow insert
Cc: max@nts.biz.ua, pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_94271_31726471.1219541497505"
X-Google-Sender-Auth: 2de56fa1c046eb3e
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/302
X-Sequence-Number: 31183

------=_Part_94271_31726471.1219541497505
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

One sensor (so one table) sends a packet each seconds (for 3000 sensors).
=> So we have : 1 insert per second for 3000 tables (and their indexes).
Hopefully there is no update nor delete in it...

------=_Part_94271_31726471.1219541497505
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">One sensor (so one table) sends a packet each seconds (for 3000 sensors). <br>=&gt; So we have : 1 insert per second for 3000 tables (and their indexes). Hopefully there is no update nor delete in it...<br><br>
</div>

------=_Part_94271_31726471.1219541497505--