One connection vs multi connection I'm redesigning my client's website in order to add about 16 mini sites for their web site. It's a website using PostgreSQL. And my question is:

Performance wise, what is the better database design:


1 (one) database, with about 190 tables, or
17 databases, one with 30 tables, and the rest with about 10 tables each.


It's for a low to middle traffic web site, but 4 or 5 times a year the traffic will be high.

It's a Centos 6 VPS, with 3 GB of RAM. Other softwares are Apache and PHP.
In postgreSQL, database is a logical concept and a PostgreSQL server manages one database-cluster which contains all databases.
The number of databases does not affect to the server performance.

I recommend that you divide databases at the viewpoint of logical structure. If your system can be completely divided into each mini site, you may create databases corresponding to the sites. (When the access of one site increases, you can divide and relocate the site to  other server.)