On Mon, Jan 29, 2007 at 11:50:35 +0900, Paul Lambert <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
