From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Partitioning V schema |
Date: | 2013-09-21 13:14:20 |
Message-ID: | CAKoxK+6Nun2Tr3j+TWPv6achN8bOO7O2D8xjKGLJGJBEyYV48g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Sep 20, 2013 at 4:38 AM, Julian <tempura(at)internode(dot)on(dot)net> wrote:
> However, I tend to go with partitions when required to be generated on
> demand dynamically and automatically (which probably isn't the case
> here). SCHEMAs have other uses, provide a level of security (GRANT) and
> useful in design when partitioning off blocks of related datasets
> completely.
I would do a partition in this case for the same reason: schemas are
much more logical divisions of data due to different grantings, search
paths, users, and so on. Partition is more a data-level split so it
does make sense when you want the data to stay in a single point but
for performance reason split it across multiple tables.
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-09-21 13:23:31 | Re: Number of WAL segment |
Previous Message | Muhammad Bashir Al-Noimi | 2013-09-21 07:08:19 | Building with MinGW issue |