Re: Tablespace on Postgrsql

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