Re: Tablespace on Postgrsql

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tablespace on Postgrsql
Date: 2013-07-24 23:26:37
Message-ID: 51F062AD.8070306@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/24/2013 1:32 PM, devonline wrote:
> We do have large Database with RAID 10. we do have Replication(Hot backup) .
> we would like to have the same on PostgreSQL when we migrate to PostgreSQL .
>
>
> Should we create separate tablespaces for Database and its objects or
> pg_default is fine as you have mentioned earlier

define 'large' ?

if its all on the same raid10 there's no performance advantage to doing
separate tablespaces. mostly, it makes administration more complicated

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message devonline 2013-07-25 00:53:56 Re: Tablespace on Postgrsql
Previous Message Lonni J Friedman 2013-07-24 21:52:43 Re: upgrading from 9.3-beta1 to 9.3-beta2 requires dump & reload?