From: Denis <socsam@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Thousands databases or schemas
Date: Thu, 8 Nov 2012 05:29:40 -0800 (PST)
Message-ID: <1352381380303-5731203.post@n5.nabble.com> (raw)
In-Reply-To: <CAEV0TzAv=BLZODAARJRwOAjQ3B=MuoZ+WntKfa4zO0OQ0wReCw@mail.gmail.com>
References: <1352367376704-5731189.post@n5.nabble.com>
<CAEV0TzAv=BLZODAARJRwOAjQ3B=MuoZ+WntKfa4zO0OQ0wReCw@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: socsam@gmail.com
Subject: Re: Thousands databases or schemas
In-Reply-To: <1352381380303-5731203.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox