X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A41559FA5FE for ; Tue, 4 Jul 2006 02:06:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34796-10 for ; Tue, 4 Jul 2006 02:06:08 -0300 (ADT) X-Greylist: delayed 00:30:18.285687 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 10C639FB1B9 for ; Tue, 4 Jul 2006 02:06:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ns2.nec.com.au (ns2.nec.com.au [147.76.180.2]) by svr4.postgresql.org (Postfix) with ESMTP id 1477F5AF025 for ; Tue, 4 Jul 2006 04:35:46 +0000 (GMT) Received: from smtp1.nec.com.au (unknown [172.31.8.18]) by ns2.nec.com.au (Postfix) with ESMTP id 68FAF3B6B9 for ; Tue, 4 Jul 2006 14:35:41 +1000 (EST) Received: from eddy (eddy.ssd.neca.nec.com.au [147.76.48.116]) by warp.ssd.neca.nec.com.au (8.12.10+Sun/8.12.10) with SMTP id k644ZduP004662; Tue, 4 Jul 2006 14:35:39 +1000 (EST) Reply-To: From: "Guoping Zhang" To: "'Chris Hoover'" , "'David Gagnon'" Cc: Subject: Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Date: Tue, 4 Jul 2006 14:35:37 +1000 Message-ID: <007801c69f23$4ce97d80$74304c93@eddy> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0079_01C69F77.1E958D80" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <1d219a6f0607031020w4c578c54x89877b8055dac756@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/12 X-Sequence-Number: 19872 This is a multi-part message in MIME format. ------=_NextPart_000_0079_01C69F77.1E958D80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Hi, Chris, In your deployment, can you put a bit more detail if available? Many thanks! My questions are: a) How do you resolve the connection pool issue? b) If each client application has many threads of connections to the remote server, what is the likely performance penalty with compare to the DBMS hosted at the same host as the client? Indeed, the application requirements may be quite different for us, but above two are my main concerns prior to doing a porting work for a large application (from other vendor DBMS). We have several idential applications on different servers, each has 250+ database connections, currently they are having a DBMS on each server but we want them to share one DBMS at a dedicate DBMS server (in the same LAN) if performance penalty is little. I wonder if anyone there can provide your comments and experience on this. Many thanks. Regards, Guoping -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Chris Hoover Sent: 2006Äê7ÔÂ4ÈÕ 3:20 To: David Gagnon Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Is postgresql ca do the job for software deployed in ASP ou SaaS mode? On 7/3/06, David Gagnon 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 is not on the website) What about the performance? Can I expect to have the same performance? I am running a similar environment. Each of our customers has a seperate database with serveral hundred tables per database. One of our servers is running over 200 customer databases with absolutely no problems. HTH, chris ------=_NextPart_000_0079_01C69F77.1E958D80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,=20 Chris,
 
In=20 your deployment, can you put a bit more detail if available? = Many=20 thanks!
 
My=20 questions are: 
 =20 a)  How do you resolve the connection=20 pool issue?
 =20 b)  If each client application has many threads of connections = to the=20 remote server, what is the likely performance penalty with compare to = the DBMS=20 hosted at the same host as the client?
 
Indeed, the application requirements may be quite = different for us,=20 but above two are my main concerns prior to doing a porting = work for=20 a large application (from other vendor DBMS). =
 
We=20 have several idential applications on different servers, each has 250+ = database=20 connections, currently they are having a DBMS on each server but we=20 want them to share one DBMS at a dedicate DBMS server (in the = same=20 LAN) if performance penalty is little. I wonder if anyone = there can=20 provide your comments and experience on this. Many=20 thanks.  
 
Regards,
Guoping
 
-----Original Message-----
From:=20 pgsql-performance-owner@postgresql.org=20 [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of = Chris=20 Hoover
Sent: 2006=C4=EA7=D4=C24=C8=D5 3:20
To: = David=20 Gagnon
Cc: = pgsql-performance@postgresql.org
Subject: Re:=20 [PERFORM] Is postgresql ca do the job for software deployed in ASP ou = SaaS=20 mode?

On 7/3/06, David = Gagnon <dgagnon@siunik.com>=20 wrote:

Can=20 I hope having several hundred of db on 1 db server?  Like = 250 dbs=20 =3D
250 client =3D 360 000 tables !!!
So is there a limit for = the number=20 of db in the db server ?(this spec is
not on the website)
What = about=20 the performance? Can I expect to have the same performance? =


I am running a similar environment.  Each of our = customers=20 has a seperate database with serveral hundred tables per = database.  One=20 of our servers is running over 200 customer databases with absolutely = no=20 problems.=20

HTH,

chris

------=_NextPart_000_0079_01C69F77.1E958D80--