Re: [PERFORM] Thousands databases or schemas

2012-11-15 Thread Bruce Momjian
On Fri, Nov 9, 2012 at 02:15:45PM +0800, Craig Ringer wrote: > On 11/08/2012 09:29 PM, Denis wrote: > > Ok guys, it was not my intention to hurt anyone's feelings by mentioning > > MySQL. Sorry about that. > It's pretty silly to be upset by someone mentioning another DB product. > I wouldn't worry

Re: [PERFORM] Thousands databases or schemas

2012-11-09 Thread Merlin Moncure
On Thu, Nov 8, 2012 at 3:36 AM, Denis wrote: > We have a web application where we create a schema or a database with a > number of tables in it for each customer. Now we have about 2600 clients. > > The problem we met using a separate DB for each client is that the creation > of new DB can take up

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Magnus Hagander
On Fri, Nov 9, 2012 at 7:15 AM, Craig Ringer wrote: > On 11/08/2012 09:29 PM, Denis wrote: >> Ok guys, it was not my intention to hurt anyone's feelings by mentioning >> MySQL. Sorry about that. > It's pretty silly to be upset by someone mentioning another DB product. > I wouldn't worry. >> There

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Craig Ringer
On 11/08/2012 09:29 PM, Denis wrote: > Ok guys, it was not my intention to hurt anyone's feelings by mentioning > MySQL. Sorry about that. It's pretty silly to be upset by someone mentioning another DB product. I wouldn't worry. > There simply was a project with a similar > architecture built using

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Mark Thornton
On 08/11/12 09:36, Denis wrote: We have a web application where we create a schema or a database with a number of tables in it for each customer. Now we have about 2600 clients. The problem we met using a separate DB for each client is that the creation of new DB can take up to 2 minutes, that i

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Pavel Stehule
Hello 2012/11/8 Denis : > 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

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Denis
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.

Re: [PERFORM] Thousands databases or schemas

2012-11-08 Thread Samuel Gendler
On Thu, Nov 8, 2012 at 1:36 AM, Denis 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