Re: Max Number of Databases on a Server. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Max Number of Databases on a Server.
Date
Msg-id 23245.1018883984@sss.pgh.pa.us
Whole thread Raw
In response to Max Number of Databases on a Server.  (daleedom@hightowergroup.com (David A. Leedom))
Responses Vacuum blocking...  (Jean-Arthur Silve <jeanarthur@eurovox.fr>)
List pgsql-admin
daleedom@hightowergroup.com (David A. Leedom) writes:
> If I created 100 separate databases on a Linux Server would this be a
> problem?  Or is the issue more related to concurrent connections?

If you're talking about multiple databases served by a single
postmaster, I don't believe it's much of an issue.  You might start to
notice performance problems when you got past a few thousands, but
that'd have more to do with kernel performance (slow lookup for many
files in one directory) than Postgres itself.

Concurrent connections is a much more interesting question, but no one
can give you any interesting answers without a lot more assumptions
than "typical Linux server".  How much iron is that really, and what
are your concurrent users going to be doing?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Juan Pablo Grassi"
Date:
Subject: Problems with PostgreSQL
Next
From: "Peter Darley"
Date:
Subject: ODBC Problem