On Wed, Jul 2, 2008 at 12:31 PM, Leví Teodoro da Silva <[EMAIL PROTECTED]> wrote: > 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 ?
There is a limit that's basically determined by the machine you're running on. Each live connection uses a bit of memory itself and there can be a few thundering herd issues with a lot of connections. that said, a big server, properly configured can handle several hundred to a few thousand connections at once. We have simple little session servers that store most of what they do in memory and handle around 700 connections with a single SATA hard drive. The data is disposable so fsync is off and we can just rebuilt one from an image in minutes if need be. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
