-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I used to run oid2name to find the relation between database names and
> .../data/base/ 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
Hi the list,
I used to run oid2name to find the relation between database names and
.../data/base/ 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 p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> In postgresql all databases are stored in /data/base directory in
> numbers form and all the related tables with that database are stored in
> that directory again in numbers form.
> so there is any command or query to see the original table nam
hi
In postgresql all databases are stored in /data/base directory in
numbers form and all the related tables with that database are stored in
that directory again in numbers form.
so there is any command or query to see the original table names.
just like:- select * from pg_stat_database; for da