Re: pg_class.relfilenode for large tables - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: pg_class.relfilenode for large tables
Date
Msg-id 20070820081154.GA20465@svana.org
Whole thread Raw
In response to pg_class.relfilenode for large tables  (Luca Ferrari <fluca1978@infinito.it>)
List 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.

Attachment

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: pg_class.relfilenode for large tables
Next
From: Dimitri Fontaine
Date:
Subject: Re: entry log