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
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 |