partitions versus databases

Поиск
Список
Период
Сортировка
От chester c young
Тема partitions versus databases
Дата
Msg-id 1323354369.98656.YahooMailClassic@web161406.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: partitions versus databases  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-sql
have an db with about 15 tables that will handle many companies.  no data overlap between companies.  is it more
efficientrun-time to use one database and index each row by company id, and one database and partition each table by
companyid, or to create a database for each company?
 

it is a web-based app using persistent connections.  no copying.


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

Предыдущее
От: Andreas
Дата:
Сообщение: Re: Question on imports with foreign keys
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: prepared statements