Re: pg_class.relfilenode for large tables

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: pg_class.relfilenode for large tables
Дата
Msg-id 20070820081154.GA20465@svana.org
обсуждение исходный текст
Ответ на pg_class.relfilenode for large tables  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general
On Mon, Aug 20, 2007 at 08:57:14AM +0200, Luca Ferrari wrote:
> 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?

No, it is a mechanism to deal with filesize limits of various OSes.
Files are cut so that each file is no more than one gigabyte. If the
table shrinks it will go away again. There's no reason to list it in
the database as it isn't an independant object.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: pg_class.relfilenode for large tables
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: entry log