Postgresql on multiple servers

Supposing a lot of user access concurrently to a postgresql database. Supposing the database is on a dedicated server which only contains postgresql. Will the database hold ? For 100 users ? 1000 ?

Another question: If i'd like to make it hold no matter how many users, is there a built-in way of separating the database onto several servers or would i have to program the separation myself by installing several postgresql ser开发者_开发问答vers and splitting the data ?

Edit: I mean transactions, not the size. And the queries I want to run are simple inserts and selects with joins.

Never tried Postgres but MySQL will serve roughly (order of magnitude) 1000 concurrent users on an average PC. After 1000 users it will "not hold". :)

please refer to this

I have had 600 concurrent connections to Postgres without performance penalty on a dedicated server, it's the most i've had. But if your planning to have that much you should consider pooled connections as suggested by @bpgergo.

It's not clear if you mean "How many user records can a single database server hold?" or "How many concurrent users (transactions) can a single database server support at a given time?".

In either case, it's going to depend on your server configuration.

Additionally, if you are talking about number of records, it will depend on the size of each record.

If you are talking about transactions, it depends on the kinds of queries you are running.

So, please provide a bit more information.