partitions versus databases

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: partitions versus databases
Date: 2011-12-08 14:26:09
Message-ID: 1323354369.98656.YahooMailClassic@web161406.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

have an db with about 15 tables that will handle many companies. no data overlap between companies. is it more efficient run-time to use one database and index each row by company id, and one database and partition each table by company id, or to create a database for each company?

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Johnston 2011-12-08 14:42:58 Re: prepared statements
Previous Message Andreas 2011-12-08 10:10:06 Re: Question on imports with foreign keys