Slide 11
Slide 11 text
sistema_db=# select relid, schemaname, relname, pg_relation_filepath(relid)
from pg_stat_user_tables;
relid | schemaname | relname | pg_relation_filepath
-------+------------+---------+----------------------
16386 | public | cliente | base/16384/16386
(1 row)
sistema_db=# select relid, indexrelid, schemaname, indexrelname,
pg_relation_filepath(indexrelid) from pg_stat_user_indexes;
relid | indexrelid | schemaname | indexrelname | pg_relation_filepath
-------+------------+------------+--------------+----------------------
16386 | 16392 | public | cliente_pkey | base/16384/16392
16386 | 16394 | public | cliente_dt_n | base/16384/16394
(2 rows)
Estrutura Física de um cluster PostgreSQL