Re: Thousands databases or schemas - Mailing list pgsql-performance

From Samuel Gendler
Subject Re: Thousands databases or schemas
Date
Msg-id CAEV0TzAv=BLZODAARJRwOAjQ3B=MuoZ+WntKfa4zO0OQ0wReCw@mail.gmail.com
Whole thread Raw
In response to Thousands databases or schemas  (Denis <socsam@gmail.com>)
Responses Re: Thousands databases or schemas
List pgsql-performance


On Thu, Nov 8, 2012 at 1:36 AM, Denis <socsam@gmail.com> 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.


pgsql-performance by date:

Previous
From: Denis
Date:
Subject: Thousands databases or schemas
Next
From: Denis
Date:
Subject: Re: Thousands databases or schemas