Re: Tablespace on Postgrsql

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: devonline <devonline(at)backpost(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tablespace on Postgrsql
Date: 2013-07-25 07:39:28
Message-ID: CAKoxK+4wgQzMG5_MZa0P9hcy3e70qsEbDQ_JHz9VuyRQcR0wvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 25, 2013 at 2:53 AM, devonline <devonline(at)backpost(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message TJ 2013-07-25 08:03:44 Speed up Switchover
Previous Message Luca Ferrari 2013-07-25 07:36:18 Re: Rule Question