Re: Tablespace on Postgrsql - Mailing list pgsql-general

From John R Pierce
Subject Re: Tablespace on Postgrsql
Date
Msg-id 51F062AD.8070306@hogranch.com
Whole thread Raw
In response to Re: Tablespace on Postgrsql  (devonline <devonline@backpost.com>)
Responses Re: Tablespace on Postgrsql
List 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



pgsql-general by date:

Previous
From: devonline
Date:
Subject: Re: Tablespace on Postgrsql
Next
From: Some Developer
Date:
Subject: Re: Why are stored procedures looked on so negatively?