Re: tables, where

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>, "postgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: tables, where
Date: 2001-03-29 16:00:40
Message-ID: 00cc01c0b86a$42c49ec0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Martín Marqués" <martin(at)bugs(dot)unl(dot)edu(dot)ar>

> Hi
> Is it a bad idea to put tables of different aplications, even if they have
> somethings in comun, in the same database?
>
> Saludos... :-)

Plus points :

+ If you need to join between tables you will *need* to do this

Minus points :

- You will need to make sure tables for application aa and bb don't have the
same name (so aa_contacts and bb_contacts)

- Security: make sure each application runs as a different user and only has
access to the tables is is supposed to.

- It is harder to back up individual applications' data

HTH

- Richard Huxton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2001-03-29 16:01:45 Re: stability problems
Previous Message Tom Lane 2001-03-29 16:00:39 Re: Pgsql-7.1RC1: SET SEED = <something>