Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group