Hi 2011/2/8 Thomas Markus <t.markus@xxxxxxxxxxxxx>: > hi, > > i would prefer many schemas. advantages: > - one backup/restore for all (or selective) > - one connection pool > - simple access to all schemas > +1 and one disadvantage - impossible separation on independent hw, when it is necessary or when you has more hw Depends on application and size of data - if you has lot of logs, or some like OLAP data, then is very practical use more than one database. Regards Pavel Stehule > regards > thomas > > > Am 08.02.2011 09:30, schrieb Szymon Guz: >> >> Hi, >> is there any noticeable difference between a cluster with many databases >> and >> a database with many schemas? >> >> I've got a quite huge database on Oracle with about 400 logically disjoint >> schemas. >> I could import that into PostgreSQL as many different databases, or as one >> database with many schemas. >> >> ÂFrom the application point of view it could be easier to have different >> databases, as for now the applications log in into different schemas, so >> this behavior wouldn't change. >> >> Do you see any drawbacks of any of the solutions? >> >> >> regards >> Szymon >> > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
