Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWSAx-0003H6-14 for pgsql-performance@postgresql.org; Thu, 08 Nov 2012 13:29:43 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWSAv-0003W1-4J for pgsql-performance@postgresql.org; Thu, 08 Nov 2012 13:29:42 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TWSAu-00030y-AD for pgsql-performance@postgresql.org; Thu, 08 Nov 2012 05:29:40 -0800 Date: Thu, 8 Nov 2012 05:29:40 -0800 (PST) From: Denis To: pgsql-performance@postgresql.org Message-ID: <1352381380303-5731203.post@n5.nabble.com> In-Reply-To: References: <1352367376704-5731189.post@n5.nabble.com> Subject: Re: Thousands databases or schemas MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201211/107 X-Sequence-Number: 48473 Samuel Gendler wrote > On Thu, Nov 8, 2012 at 1:36 AM, Denis < > socsam@ > > wrote: > >> >> P.S. >> Not to start a holywar, but FYI: in a similar project where we used MySQL >> now we have about 6000 DBs and everything works like a charm. >> > > You seem to have answered your own question here. If my recollection of a > previous discussion about many schemas and pg_dump performance is > accurate, > I suspect you are going to be told that you've got a data architecture > that > is fairly incompatible with postgresql's architecture and you've > specifically ruled out a solution that would play to postgresql's > strengths. Ok guys, it was not my intention to hurt anyone's feelings by mentioning MySQL. Sorry about that. There simply was a project with a similar architecture built using MySQL. When we started the current project, I have made a decision to give PostgreSQL a try. Now I see that the same architecture is not applicable if PostgreSQL is used. I would recommend you to refresh the info here http://wiki.postgresql.org/wiki/FAQ. There is a question "What is the maximum size for a row, a table, and a database?". Please add there info on maximum DBs number and tables number one DB can contain while PostgreSQL continues to work properly. PS: the easiest solution in my case is to create initially 500 DBs (like app_template_[0-500]) and create up to 500 schemas in each of it. This will make 250000 possible clients in total. This should be enough. The question is: can you see the possible pitfalls of this solution? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Thousands-databases-or-schemas-tp5731189p5731203.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.