Re: Load balancing across disks

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Load balancing across disks
Date: 2007-01-29 16:17:19
Message-ID: 20070129161719.GA10875@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 29, 2007 at 11:50:35 +0900,
Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> wrote:
>
> In order to balance disk load and ensure faster data access, my current
> SQL server setup has the data spread across 3 physical disk devices. One
> question I would like to know which I can't find in the documentation
> I've been reading is if Postgres has any similar data distribution
> abilities.
>
> I.e. can I create a data file on D drive which holds tables a, b and e,
> and a data file on E drive which holds tables c, d and f.
>
> If this is possible, could someone point me to some documentation so I
> can experiment a little.

http://developer.postgresql.org/pgdocs/postgres/manage-ag-tablespaces.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ZappA 2007-01-29 16:38:42 Crazy Error
Previous Message Alvaro Herrera 2007-01-29 15:57:47 Re: strange thing with partitioning / rules / plpgsql