Re: Tablespace on Postgrsql - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Tablespace on Postgrsql
Date
Msg-id CAKoxK+4wgQzMG5_MZa0P9hcy3e70qsEbDQ_JHz9VuyRQcR0wvA@mail.gmail.com
Whole thread Raw
In response to Re: Tablespace on Postgrsql  (devonline <devonline@backpost.com>)
Responses Re: Tablespace on Postgrsql  (devonline <devonline@backpost.com>)
List pgsql-general
On Thu, Jul 25, 2013 at 2:53 AM, devonline <devonline@backpost.com> wrote:
> Our current database size is
>
> 1 Terabyte
>

The idea behind tablespaces is to gain I/O scattering data (and
therefore requests) across different devices. Therefore you have to
identify first if your database can be "scattered" across different
devices (not different partiion of the same hdd) and then decide which
parts need to get more bandwidth ajnd which can get fewer.

Luca


pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Rule Question
Next
From: Some Developer
Date:
Subject: Re: Why are stored procedures looked on so negatively?