Search Postgresql Archives

Re: pg_class.relfilenode for large tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux