-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I used to run oid2name to find the relation between database names and > .../data/base/<dir> but i'm interested also to identify relation between table > names, index names and files number as would try to decrease Wait I/O by > setting tables on one disk and indexes on another one. > The tables pg_class and pg_index do not give the symbolic name with the > "numbers". This is probably not what you want to do - there are less drastic ways to get more performance out of PostgreSQL. One thing you can do is move your WAL files to a different disk, as they are very heavily accessed. (this is the pg_xlog directory). There are lots of other things that can help as well - post your hardware and/or queries to the performance list and you should get some good responses: http://tinyurl.com/yc2b - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200312081935 -----BEGIN PGP SIGNATURE----- iD8DBQE/1RlYvJuQZxSWSsgRAjV4AJ9uvU5e4yStJSWLhEJZXW/TEiiDGgCgmwKM rymCF633HioUBJQ0Oj0obZg= =rf6h -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
