pg_class.relfilenode for large tables

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема pg_class.relfilenode for large tables
Дата
Msg-id 200708200857.14788.fluca1978@infinito.it
обсуждение исходный текст
Ответы Re: pg_class.relfilenode for large tables
Список 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@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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Help with this query (some join stuff I think)
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: pg_class.relfilenode for large tables