Re: [PERFORM] Is postgresql ca do the job for software deployed in

2006-07-05 Thread Markus Schaber
Hi, Gregory, Gregory S. Williamson wrote: > A sodden late night idea ... schemas don't need to have names that > are meaningful to outsiders. Yes, but having schema names like A34FZ37 not only qualifies for thedailywtf.com, but also tends to produce maintainance nightmares. And it still allows t

Re: [PERFORM] Is postgresql ca do the job for software deployed in

2006-07-05 Thread Gregory S. Williamson
lobeXplorer LLC -Original Message- From: [EMAIL PROTECTED] on behalf of Markus Schaber Sent: Wed 7/5/2006 3:38 AM To: pgsql-performance@postgresql.org Cc: Subject: Re: [PERFORM] Is postgresql ca do the job for software deployed in Hi, Mikael, Just my 2 cents: Mikael Carneh

Re: [PERFORM] Is postgresql ca do the job for software deployed in

2006-07-05 Thread Markus Schaber
Hi, Mikael, Just my 2 cents: Mikael Carneholm wrote: > Do you really need to create one *DB* per client - that is, is one > schema (in the same DB) per client out of the question? Sometimes, schemas would work _technically_, but not politically, as a postgresql user cannot be prevented from list

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP

2006-07-04 Thread David Gagnon
li 2006 13:42 To: pgsql-performance@postgresql.org Subject: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Hi all, I've been working on my personal project for 3.5 years now. I developed an ERP system in web/java. Now the people I will work with s

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-04 Thread Mikael Carneholm
> Sent: den 3 juli 2006 13:42 > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Is postgresql ca do the job for software deployed in > ASP ou SaaS mode? > > Hi all, > > I've been working on my personal project for 3.5 years now. I > developed an ERP sy

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP

2006-07-04 Thread David Gagnon
performance@postgresql.org Subject: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Hi all, I've been working on my personal project for 3.5 years now. I developed an ERP system in web/java. Now the people I will work with suggest to offers it in Saas

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-04 Thread Mikael Carneholm
2006 13:42 To: pgsql-performance@postgresql.org Subject: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Hi all, I've been working on my personal project for 3.5 years now. I developed an ERP system in web/java. Now the people I will work with suggest to offe

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-03 Thread Guoping Zhang
thanks.     Regards, Guoping   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Chris HooverSent: 2006Äê7ÔÂ4ÈÕ 3:20To: David GagnonCc: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Is postgresql ca do the job for software deployed in

Re: [PERFORM] Is postgresql ca do the job for software deployed in

2006-07-03 Thread Craig A. James
Richard Broersma Jr wrote: Each table with-in the database is assigned an OID and is located inside the DB directory. So if there is a file-system limitation on the number of files with-in a given directory it would also be a limit to the number of tables that could be created for each databas

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-03 Thread Chris Hoover
On 7/3/06, David Gagnon <[EMAIL PROTECTED]> wrote: Can I hope having several hundred of db on 1 db server?  Like 250 dbs =250 client = 360 000 tables !!!So is there a limit for the number of db in the db server ?(this spec isnot on the website)What about the performance? Can I expect to have the sa

Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-03 Thread Richard Broersma Jr
> Typically I will have 1db per client and around 150 tables per db. So > since I hope I didn`t work all those year for nothing .. I expect to > have bunch of clients witch means the same amount of db since I have 1 > db/client. > > Can I hope having several hundred of db on 1 db server? Lik

[PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode?

2006-07-03 Thread David Gagnon
Hi all, I've been working on my personal project for 3.5 years now. I developed an ERP system in web/java. Now the people I will work with suggest to offers it in Saas mode. Which means my customer will connect to my website and found they ERP software and data there. It's not the deploy