partitions versus databases - Mailing list pgsql-sql

From chester c young
Subject partitions versus databases
Date
Msg-id 1323354369.98656.YahooMailClassic@web161406.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: partitions versus databases
List 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 by date:

Previous
From: Andreas
Date:
Subject: Re: Question on imports with foreign keys
Next
From: "David Johnston"
Date:
Subject: Re: prepared statements