On 30/09/2016 18:45, Rakesh Kumar wrote:
I've been reading this discussion with great interest, to see what other
Postgres experts think. :-)
I am bit disappointed that most of the replies are questioning why we are
doing what we are doing. Once again, we (db designers) have no choice
in that. What I would like to know that which one is better :- multiple db
vs multiple schema. Read few interesting arguments and noted that
connection pooling works better with multiple schemas than dbs. Anything else?
Since you missed it, i write it once again :
same organization (e.g. holding) -> schemas
different organizations -> DBs
thanks
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general