Which gives good performance? separate database vs separate schema

Поиск
Список
Период
Сортировка
От Divakar Singh
Тема Which gives good performance? separate database vs separate schema
Дата
Msg-id 991565.83793.qm@web65414.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы Re: Which gives good performance? separate database vs separate schema
Re: Which gives good performance? separate database vs separate schema
Список pgsql-performance
Hello Friends,
I have many instances of my software running on a server (Solaris SPARC). Each software instance requires some DB tables (same DDL for all instances' tables) to store data.
It essentially means that some processes from each instance of the software connect to these tables.
Now, should I put these tables in 1 Database's different schemas or in separate databases itself for good performance?
I am using libpq for connection.  

Pictorial Representation:

Process1 -> DB1.schema1.table1

Process2 -> DB1.schema2.table1

  Vs.

Process1 -> DB1.default.table1

Process2 -> DB2.default.table1

Which one is better?


 
thanks in advance

В списке pgsql-performance по дате отправления:

Предыдущее
От: Markus Schulz
Дата:
Сообщение: problem with from_collapse_limit and joined views
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Which gives good performance? separate database vs separate schema