On Mon, Jan 19, 2009 at 12:10 PM, Rubén F. <rfs1986@xxxxxxxxx> wrote: > First of all, excuse my english... > > I have a doubt. I am designing a program for manage CV's. This program > connect with a PostgresDB. This program will be used for 5,000 persons > becaus it will be used in a University. Then, ¿how many actives connection > could be postgres? ¿does it support a very big cuantity of information? > > Possibly, in the future, the program will grow up with more information and > more users. ¿can i use in this case postgres?¿has it a good scalability? We have database servers where the PostgreSQL instances are configured to support on the order of a thousand concurrent connections, and definitely have hundreds active at a time fairly frequently, so that kind of scalability is certainly possible. To support that, we have rather powerful hardware; that's not running on "a cheap PC with an IDE disk drive." It would actually be pretty unusual for the sort of application you are describing to actually require thousands of concurrent connections. There may be thousands of users accessing the application, but the database access is likely to be sporadic. Web application frameworks typically offer support for "connection pools" so that a much smaller number of actual database connections is used to support a large number of users. As for quantity of data, any respectable database can store very large quantities of data. "Many gigabytes" should be easy. Terabytes are where the challenges begin, but there certainly are organizations using PostgreSQL to support terabyte-sized databases. -- http://linuxfinances.info/info/linuxdistributions.html Katharine Hepburn - "Death will be a great relief. No more interviews." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
