Re: pg_class.relfilenode for large tables

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.