pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSchema partitioning
3+ messages / 3 participants
[nested] [flat]
* Schema partitioning
@ 2011-09-01 18:13 Charlie <scorpdaddy@hotmail.com>
2011-09-02 13:20 ` Re: Schema partitioning David Johnston <polobo@yahoo.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-01 18:13 Schema partitioning Charlie <scorpdaddy@hotmail.com>
@ 2011-09-02 13:20 ` David Johnston <polobo@yahoo.com>
2011-09-02 13:22 ` Re: Schema partitioning Little, Douglas <DOUGLAS.LITTLE@orbitz.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-01 18:13 Schema partitioning Charlie <scorpdaddy@hotmail.com>
2011-09-02 13:20 ` Re: Schema partitioning David Johnston <polobo@yahoo.com>
@ 2011-09-02 13:22 ` Little, Douglas <DOUGLAS.LITTLE@orbitz.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