Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 215DC650040 for ; Sat, 5 Jul 2008 07:40:09 -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 61169-02 for ; Sat, 5 Jul 2008 07:40:04 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id A82CC64FD34 for ; Sat, 5 Jul 2008 07:40:08 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m65Ae4Q6062372 for ; Sat, 5 Jul 2008 07:40:04 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m65APFxe051884 for pgsql-performance@postgresql.org; Sat, 5 Jul 2008 07:25:15 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: [QUESTION]Concurrent Access Date: Fri, 04 Jul 2008 12:58:48 -0400 Organization: cbbrowne Computing Inc Lines: 27 Message-ID: <87hcb5ziuv.fsf@dba2.int.libertyrms.com> References: <4a74ba520807021131l28308633yf0ad5416a7055f9@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.21 (linux) Cancel-Lock: sha1:PWK8dLR1rngO6bPeZ6fmbg3fTYE= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/50 X-Sequence-Number: 30650 tlevisilva@gmail.com ("Leví 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 DataBase > 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 time. > 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."