What is the role of pg_filenode.map ?
What is the role of pg_filenode.map ?
От:
"F. BROUARD / SQLpro" <sqlpro@club-internet.fr>
Дата:
Hi tehre, in every database there is a file nammed pg_filenode.map wich I suppose give the map of the real filenode while some command make a divergence betwen the actuel object oid and the "new" filenode... Am I wright ? Thanks -- Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66 Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence Audit, conseil, expertise, formation, modélisation, tuning, optimisation *********************** http://www.sqlspot.com *************************
Re: What is the role of pg_filenode.map ?
От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
"F. BROUARD / SQLpro" wrote: > in every database there is a file nammed pg_filenode.map wich I > suppose give the map of the real filenode while some command make > a divergence betwen the actuel object oid and the "new" filenode... > Am I wright ? If you want to understand internals like this, the best thing to do is probably to read the source code. http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/utils/cache/relmapper.c;h=6f214957bf831c4a5c17ebc630f5151adc860135;hb=HEAD -Kevin