pg_class.relfilenode for large tables

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_class.relfilenode for large tables
Date: 2007-08-20 06:57:14
Message-ID: 200708200857.14788.fluca1978@infinito.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
when a table becomes large a new file on disk is created. Such file has the
name compound by the pg_class.relfilenode attribute and an incremental index.
However it seems to me this does not appears in the pg_class table. Is there
any place where this extra file appears?

As an example:

postgres(at)fluca:~$ ls -l /opt/database/24601/41098* -h
-rw------- 1 postgres postgres 1,0G 2007-08-20 08:48 /opt/database/24601/41098
-rw------- 1 postgres postgres 202M 2007-08-20
08:49 /opt/database/24601/41098.1

select oid, * from pg_class where relname='large';

oid | relname | relnamespace | reltype | relowner | relam | relfilenode |
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers |
relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
relhassubclass | relfrozenxid | relacl | reloptions
-------+---------+--------------+---------+----------+-------+-------------+---------------+----------+-------------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------------+--------+------------
41098 | large | 2200 | 41099 | 16386 | 0 | 41098 |
0 | 156813 | 1.12921e+07 | 0 | 0 | f |
f | r | 9 | 0 | 0 | 0 |
0 | 0 | f | f | f | f |
11412913 | |
(1 riga)

Thanks,
Luca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-08-20 07:23:05 Re: Help with this query (some join stuff I think)
Previous Message Robin Helgelin 2007-08-20 06:25:37 Re: entry log