Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5029665067F for ; Mon, 14 Jul 2008 11:23:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38893-01 for ; Mon, 14 Jul 2008 11:23:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by postgresql.org (Postfix) with ESMTP id E918A65067A for ; Mon, 14 Jul 2008 11:23:04 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so1238343yxb.73 for ; Mon, 14 Jul 2008 07:23:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=ENbA3hMWK0/oxpBGLaG7jaKnO2weSHhBGPqmAcY/jO8=; b=oCPcf4JpSPDi4rOeOreS0FKzhZx+ugUUWmCU15Bhmdw/jVZtt7wq7zzQmJxVsGqvVL DLtca+3eAB8PcwpC0eSDCJVpfFiKvuneuWCuFK07yJ+8u5wtQNjmqxkXhtKLN1g4C1y+ 2F4HplUZV20mvw6h+AjVRZ4Ii181o31K1dycE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=qvOwCoLaQr//wQgzvdHycAHa8hDlspPHwf+rGJibuE0GzgimxnzYwv7Cojig1A7z4R e6yGHQcm5ZFFudLUcs2YT15xldhN/7En2o/GpBoKehfa4VHem5ImE5WDJ2AAw11MSoV7 P/drhDgFtton8wGisIvE0kXc5dpHyY7/htaEM= Received: by 10.142.72.21 with SMTP id u21mr4243951wfa.161.1216045381838; Mon, 14 Jul 2008 07:23:01 -0700 (PDT) Received: by 10.143.1.11 with HTTP; Mon, 14 Jul 2008 07:23:01 -0700 (PDT) Message-ID: <4a74ba520807140723o2bb0af58q96772eaf62704fa7@mail.gmail.com> Date: Mon, 14 Jul 2008 11:23:01 -0300 From: "=?ISO-8859-1?Q?Lev=ED_Teodoro_da_Silva?=" To: pgsql-performance@postgresql.org Subject: Re: [QUESTION]Concurrent Access In-Reply-To: <87hcb5ziuv.fsf@dba2.int.libertyrms.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25897_22856843.1216045381847" References: <4a74ba520807021131l28308633yf0ad5416a7055f9@mail.gmail.com> <87hcb5ziuv.fsf@dba2.int.libertyrms.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/127 X-Sequence-Number: 30727 ------=_Part_25897_22856843.1216045381847 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi guys !!! Sorry for the wrong spelling. =3D) I could see that PostgreSQL will support my application, but i have to do a good configuration on my server. Thanks for answers, now i will look for informations about PostgreSQL on OpenSolaris 2008.05 Have a nice week, Levi 2008/7/4 Chris Browne : > tlevisilva@gmail.com ("Lev=ED Teodoro da Silva") writes: > > Hi guys, How are you ? > > I am from Brazil and i work for a little company and it company is > working is medium-big project and we want to use PostGree like the DataBa= se > > system, but i got some questions. > > I want to know if the PostGree has limitations about the concurrent > access, because a lot of people will access this database at the same tim= e. > > I want to know about the limitations, like how much memory do i have to > use !? How big could be my database and how simultaneously access this > > database support ? > > PostGree is a system I am not familiar with; this list is for > discussion of PostgreSQL, sometimes aliased as "Postgres," so I will > assume you are referring instead to PostgreSQL. > > PostgreSQL does have limitations; each connection spawns a process, > and makes use of its own "work_mem", which has the result that the > more connections you configure a particular backend to support, the > more memory that will consume, and eventually your system will > presumably run out of memory. > > The size of the database doesn't have as much to do with how many > users you can support as does the configuration that you set up. > -- > select 'cbbrowne' || '@' || 'linuxfinances.info'; > http://cbbrowne.com/info/lsf.html > Rules of the Evil Overlord #145. "My dungeon cell decor will not > feature exposed pipes. While they add to the gloomy atmosphere, they > are good conductors of vibrations and a lot of prisoners know Morse > code." > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org= ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > ------=_Part_25897_22856843.1216045381847 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi guys !!!

Sorry for the wrong spelling. =3D)
I could see that P= ostgreSQL will support my application, but i have to do a good configuratio= n on my server.

Thanks for answers, now i will look for informations= about PostgreSQL on OpenSolaris 2008.05
Have a nice week,
Levi


2008/7/4 Ch= ris Browne <cbbrowne@acm.org>= :
tlevisilva@gmail.com ("Lev=ED Teodoro da Silva") writes: > Hi guys, How are you ?
> I am from Brazil and i work for a little company and it company is wor= king is medium-big project and we want to use PostGree like the DataBase > system, but i got some questions.
> I want to know if the PostGree has limitations about the concurrent ac= cess, because a lot of people will access this database at the same time. > I want to know about the limitations, like how much memory do i have t= o use !? How big could be my database and how simultaneously access this > database support ?

PostGree is a system I am not familiar with; this list is for discussion of PostgreSQL, sometimes aliased as "Postgres," so I w= ill
assume you are referring instead to PostgreSQL.

PostgreSQL does have limitations; each connection spawns a process,
and makes use of its own "work_mem", which has the result that th= e
more connections you configure a particular backend to support, the
more memory that will consume, and eventually your system will
presumably run out of memory.

The size of the database doesn't have as much to do with how many
users you can support as does the configuration that you set up.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://cbbr= owne.com/info/lsf.html
Rules  of the  Evil Overlord  #145. "My  dungeon c= ell  decor  will not
feature exposed pipes.  While they add to the  gloomy atmosphere,= they
are good  conductors of vibrations and  a lot of  prisoners = know Morse
code." <= http://www.eviloverlord.com/>

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

------=_Part_25897_22856843.1216045381847--