Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoWNt-0004d4-6B for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 10:42:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoWNs-0003VV-Cw for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 10:42:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoWNr-0003VJ-59 for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 10:42:15 +0000 Received: from nm34-vm2.bullet.mail.bf1.yahoo.com ([72.30.239.74]) by makus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoWNn-0002co-HY for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 10:42:14 +0000 Received: from [98.139.215.143] by nm34.bullet.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 10:42:10 -0000 Received: from [98.139.212.246] by tm14.bullet.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 10:42:10 -0000 Received: from [127.0.0.1] by omp1055.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 10:42:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 616784.96643.bm@omp1055.mail.bf1.yahoo.com Received: (qmail 66699 invoked by uid 60001); 5 Dec 2013 10:42:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s1024; t=1386240130; bh=uuaKUvPL0y+dKZu7RxYuf+q6+5jQLwAwN+9vrThUaoY=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=nJ9cO8oaoixQLrd4tzuxasocaCpF/1cqY5o6fTk3ZBZTXqiheYQqN87U9FouUQ0fWlkQCLlBGQAmNumHtkcrm0y2AxkOOdLig8hgYN/XY67CKKp4/jgy9l/LGUZ+ubGI3A0O+cE1i5U7T5eDOeWsSR5ga+Xl9y8fRgerAuRZO5w= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=c5C4Vay8PUcFcynV8KRx9gOHza0HOvjqdSpEK5lic8D0qIyBLLpXhYo9E81oj3Lik8kl2JgyxyXuIA6VTk1k4I7FseiWJ/Oa2YsxkVK4yeM8jgmgk3g7yGWsNLDjdAhe7reA9O9wWlN1Zd9SO94iny5WMep6ktQMRLMKbEjnG74=; X-YMail-OSG: iULr6cYVM1k_mH31uuwBp.0iamY0UvDVwclrzhWxlNU7PZH ZKddYFtk5hIri8.g.bMD6s.mYBHtAc0NG1b.vugFOUQSGzGnV8qlJvZXlc9U KhnONzQbJU6vr2fed.RlvC0FruP6iCVSDdPGeh6jYY4LJPa6seVqopb6EY.6 u1fcH75ho.pj071JkeOG8MUjsyrtfvazoqZZVCk9.5lYFwq.0J6UDvu1wfvJ A8QETfoa7RcRgDnwtmdRrhBF5cVG.w_WmitmzJrupmi3sUEXzgO440cSDOBP Q93_zBdnagKeWn82AkW8.MPePvg4hzQPPi0ZFK2yGVhlYf4xUPeKhmSnLu4j agRrwLln5jcZAzyucAmKm3xKQ4e4BUx7NaPMuXtSrTEakI4fqratDr8Mq9ji laa6UA9Zflo77Jtlab1X7fXOQ2yYlBNJnc90sjPSKPCVr7Gs4Q8dAZfy5Bvn 64HcWxnHGrzlkak94fkgF283WmCT5ttMG3EgIv9aTgibOBwjo2or2xWDwzGL VUH2C3mn30xYxbIZSeFUrwAapro1cgtV1Bq7WQ2.PXEgHF3q_QxGPt1fFQ0u XPvofY9zyGfD0D46W Received: from [189.73.169.37] by web163002.mail.bf1.yahoo.com via HTTP; Thu, 05 Dec 2013 02:42:10 PST X-Rocket-MIMEInfo: 002.001, SGVsbG8sCgpXZSBhcmUgc3RhcnRpbmcgYSBuZXcgcHJvamVjdCB0byBkZXBsb3kgYSBzb2x1dGlvbiBpbiBjbG91ZCB3aXRoIHRoZSBwb3NzaWJpbGl0eSB0byBiZSB1c2VkIGZvciAyLjAwMCsgY2xpZW50cy4gRWFjaCBvZiB0aGlzIGNsaWVudHMgd2lsbMKgdXNlIHNldmVyYWwgdGFibGVzIHRvIHN0b3JlIHRoZWlyIGluZm9ybWF0aW9uIChvdXIgbW9kZWwgaGFzIGFib3V0IDUwMCsgdGFibGVzIGJ1dCB0aGVyZSdzIGxlc3MgdGhhbiAxMDAgY29yZSB0YWJsZSB3aXRoIGhlYXZ5IHVzZSkuIEFsc28gdGhlIHABMAEBAQE- X-Mailer: YahooMailWebService/0.8.169.609 References: Message-ID: <1386240130.78000.YahooMailNeo@web163002.mail.bf1.yahoo.com> Date: Thu, 5 Dec 2013 02:42:10 -0800 (PST) From: Max Reply-To: Max Subject: One huge db vs many small dbs To: "pgsql-performance@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1211669884-429297192-1386240130=:78000" X-Pg-Spam-Score: 1.7 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ---1211669884-429297192-1386240130=:78000 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello,=0A=0AWe are starting a new project to deploy a solution in cloud wit= h the possibility to be used for 2.000+ clients. Each of this clients will= =A0use several tables to store their information (our model has about 500+ = tables but there's less than 100 core table with heavy use). Also the proje= cted ammout of information per client could be from small (few hundreds tup= les/MB) to huge (few millions tuples/GB).=0A=0AOne of the many questions we= have is about performance of the db if we work with only one (using a Clie= ntID to separete de clients info) or thousands of separate dbs. The managem= ent=A0of the dbs is not a huge concert as we have an automated tool.=0A=0AA= t Google there's lots of cases about this subject but none have a scenario = that=A0matchs with the one I presented above, so I would like to know if an= yone here has a similar situation or knowledgement and could share some tho= ughts.=0A=0A=0AThanks=0A=0AMax ---1211669884-429297192-1386240130=:78000 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hello,

We are starting a new project to depl= oy a solution in cloud with the possibility to = be used for 2.000+ clients. Each of this clients will use several tables to store their information (our model has ab= out 500+ tables but there's less than 100 core ta= ble with heavy use). Also the projected ammout of= information per client could be from small (few hundreds tuples/MB) to huge (few millions tuples/GB).

One of the many questions we hav= e is about performance of the db if we work with only one (using a ClientI<= /span>D to separete de clients info) or thousands of separate dbs. = The management of the dbs is not a huge conc= ert as we have an automated tool.

At= Google there's lots of cases about this subject but none have = a scenario that matchs with the one I pres= ented above, so I would like to know if anyone here has a similar situation or knowledgement and could share some thoughts= .

Thanks
<= div id=3D"yiv7475184515yui_3_13_0_ym1_1_1386238796642_8029" style=3D"color:= rgb(0, 0, 0); font-size: 13px; font-family: monospace; background-color: t= ransparent; font-style: normal;">
Max
---1211669884-429297192-1386240130=:78000--