On Tuesday 17 February 2004 12:54, Konstantin Tokar wrote:
> Hi!
> Does PostgreSQL allow to create tables and indices of a single
> database on multiple disk drives with a purpose of increase
> performance as Oracle database does? If a symbolic reference is the
> only method then the next question is: how can it be determined what
> file is referred to what table and index?
Yep, symlinks are the way at present (though I think someone is working on
tablespace support). The files are named after the OID of the object they
represent - there is a useful oid2name utility in the contrib/ folder.
You might want to check the archives though, and see what RAID setups people
prefer - less trouble to maintain than symlinking.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
