Skip site navigation (1) Skip section navigation (2)

Re: [QUESTION]Concurrent Access

From: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [QUESTION]Concurrent Access
Date: 2008-07-14 14:23:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hi guys !!!

Sorry for the wrong spelling. =)
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,

2008/7/4 Chris Browne <cbbrowne(at)acm(dot)org>:

> tlevisilva(at)gmail(dot)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' || '@' || '';
> 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(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-07-14 18:08:13
Subject: Re: Trigger is taking time to fire
Previous:From: PraveenDate: 2008-07-14 09:51:50
Subject: Re: Trigger is not firing immediately

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group