DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=ET8LHeo7J7oOl6w0Gqvvul/cNI6ZJRMPBplcUflrQT8vaOHMcflgaj1fvUg3fQgf6FZcspPtg0+eSokYkMOxiR7XbHLcnY2UrLh8DKe3boE7uiRfOwjeqOVl321aA9xoIhrpax1N6OqCgZXz49dRqa4KiDcJ0BBlj2oPbjw6H50=
	;
References: <BLU0-SMTP160E0FDF5187168D1BA6EC2CE190@phx.gbl>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: <BLU0-SMTP160E0FDF5187168D1BA6EC2CE190@phx.gbl>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <F294EC88-9E96-4FAB-81C1-0F24B235E641@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: Schema partitioning
Date: Fri, 2 Sep 2011 09:20:03 -0400
To: Charlie <scorpdaddy@hotmail.com>


On Sep 1, 2011, at 14:13, Charlie <scorpdaddy@hotmail.com> wrote:

> Could I get feedback from the community on schema partitioning?
>=20
> I'm doing maintenance on my ddl and I'm noticing that my tables are all in=
 1 schema, but they have prefixes on their names like table_app1_sometable, t=
able_app1_secondtable,  table_app2_anothertable, table_priviledged_restricte=
dtable1, etc.  The table_app1 tables seem to want to go in their own schema "=
app1", etc, and drop the prefixes.  Except they'll still be there, as in app=
1.sometable.
>=20
> Is this just style?  Or are there concrete benefits to partitioning?
>=20
>=20

Mostly style but some ease-of-use when it comes to permissions as well.  It'=
s really no different than why you'd use sub-directories in your OS instead o=
f putting everything in C/root.

It does give you namespaces features as well (I.e., duplicate names but in d=
ifferent contexts).

David J.=