pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Schema partitioning
3+ messages / 3 participants
[nested] [flat]

* Schema partitioning
@ 2011-09-01 18:13  Charlie <scorpdaddy@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Charlie @ 2011-09-01 18:13 UTC (permalink / raw)
  To: pgsql-sql

Could I get feedback from the community on schema partitioning?

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, table_app1_secondtable,  table_app2_anothertable, table_priviledged_restrictedtable1, 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 app1.sometable.

Is this just style?  Or are there concrete benefits to partitioning?


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Schema partitioning
@ 2011-09-02 13:20  David Johnston <polobo@yahoo.com>
  parent: Charlie <scorpdaddy@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: David Johnston @ 2011-09-02 13:20 UTC (permalink / raw)
  To: Charlie <scorpdaddy@hotmail.com>; +Cc: pgsql-sql



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

> Could I get feedback from the community on schema partitioning?
> 
> 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, table_app1_secondtable,  table_app2_anothertable, table_priviledged_restrictedtable1, 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 app1.sometable.
> 
> Is this just style?  Or are there concrete benefits to partitioning?
> 
> 

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 of putting everything in C/root.

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

David J.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Schema partitioning
@ 2011-09-02 13:22  Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
  parent: David Johnston <polobo@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Little, Douglas @ 2011-09-02 13:22 UTC (permalink / raw)
  To: David Johnston <polobo@yahoo.com>; Charlie <scorpdaddy@hotmail.com>; +Cc: pgsql-sql

I generally would separate different apps into different schema. 

doug

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of David Johnston
Sent: Friday, September 02, 2011 8:20 AM
To: Charlie
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Schema partitioning



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

> Could I get feedback from the community on schema partitioning?
> 
> 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, table_app1_secondtable,  table_app2_anothertable, table_priviledged_restrictedtable1, 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 app1.sometable.
> 
> Is this just style?  Or are there concrete benefits to partitioning?
> 
> 

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 of putting everything in C/root.

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

David J.
-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2011-09-02 13:22 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-01 18:13 Schema partitioning Charlie <scorpdaddy@hotmail.com>
2011-09-02 13:20 ` David Johnston <polobo@yahoo.com>
2011-09-02 13:22   ` Little, Douglas <DOUGLAS.LITTLE@orbitz.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox