Re: find table name

-----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 greg@turnstep.com
PGP Key: 0x14964AC8 200312081935

-----BEGIN PGP SIGNATURE-----

iD8DBQE/1RlYvJuQZxSWSsgRAjV4AJ9uvU5e4yStJSWLhEJZXW/TEiiDGgCgmwKM
rymCF633HioUBJQ0Oj0obZg=
=rf6h
-----END PGP SIGNATURE-----