| 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: | Whole Thread | Raw Message | 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
| 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 |