On 7/25/2013 10:16 PM, Atri Sharma wrote:
On Fri, Jul 26, 2013 at 7:21 AM, devonline<devonl...@backpost.com> wrote:
>Thanks for the in formation. Can you please tell me what would be a scalable
>architecture? (using pg_default) or separate custom tablespaces
Putting too may tables in one tablespace can lead to confusion, to say
the least. Keeping logically separate tablespaces seems a much saner
idea to me, IMHO.
schema are the appropriate structure for logically grouping tables if
you have a large number.
tablespaces are purely about the storage.
as I said before, if your server has only one main data raid with one
big file system, then a single tablespace is appropriate. if your
server has multiple distinct raids and volumes, then different
tablespaces are appropriate.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
