Re: Tablespace on Postgrsql

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: devonline <devonline(at)backpost(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tablespace on Postgrsql
Date: 2013-07-26 05:16:08
Message-ID: CAOeZVidCH3iq+FpVTgjgufgUaRFA88FGp7ObGkhtw-+S4DHdeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 26, 2013 at 7:21 AM, devonline <devonline(at)backpost(dot)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.

But if your number of tables is limited, I would suggest using default
tablespace.

Regards,

Atri
--
Regards,

Atri
l'apprenant

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2013-07-26 05:27:29 Re: Fastest Index/Algorithm to find similar sentences
Previous Message Sergey Konoplev 2013-07-26 05:00:23 Re: Speed up Switchover