Re: thousand unrelated data files in pg_default tablespace

Hello

there is a dump from 8KB files

Regard

Pavel Stehule
>
> *******************************************************************
> * PostgreSQL File/Block Formatted Dump Utility - Version 8.3.0
> *
> * File: /srv/postgresql/data/base/3400014/27059918
> * Options used: None
> *
> * Dump created on: Tue Aug 31 12:57:23 2010
> *******************************************************************
>
> Block    0 ********************************************************
> <Header> -----
>  Block Offset: 0x00000000         Offsets: Lower      40 (0x0028)
>  Block: Size 8192  Version    4            Upper    8000 (0x1f40)
>  LSN:  logid      0 recoff 0x00000000      Special  8192 (0x2000)
>  Items:    4                      Free Space: 7960
>  TLI: 0x0000  Prune XID: 0x00000000  Flags: 0x0000 ()
>  Length (including item array): 40
>
> <Data> ------
>  Item   1 -- Length:   47  Offset: 8144 (0x1fd0)  Flags: NORMAL
>  Item   2 -- Length:   47  Offset: 8096 (0x1fa0)  Flags: NORMAL
>  Item   3 -- Length:   47  Offset: 8048 (0x1f70)  Flags: NORMAL
>  Item   4 -- Length:   47  Offset: 8000 (0x1f40)  Flags: NORMAL
>
>
> *** End of File Encountered. Last Block Read: 0 ***
> $ ls -l /srv/postgresql/data/base/3400014/27059918
> -rw------- 1 postgres postgres 8192 Jul  1 06:28 /srv/postgresql/data/base/3400014/27059918
>
>
>
> $ ./pg_filedump /srv/postgresql/data/base/3400014/27059926
>
> *******************************************************************
> * PostgreSQL File/Block Formatted Dump Utility - Version 8.3.0
> *
> * File: /srv/postgresql/data/base/3400014/27059926
> * Options used: None
> *
> * Dump created on: Tue Aug 31 13:00:17 2010
> *******************************************************************
>
> Block    0 ********************************************************
> <Header> -----
>  Block Offset: 0x00000000         Offsets: Lower      48 (0x0030)
>  Block: Size 8192  Version    4            Upper    8176 (0x1ff0)
>  LSN:  logid      0 recoff 0x00000000      Special  8176 (0x1ff0)
>  Items:    6                      Free Space: 8128
>  TLI: 0x0001  Prune XID: 0x00000000  Flags: 0x0000 ()
>  Length (including item array): 48
>
>  BTree Meta Data:  Magic (0x00053162)   Version (2)
>                    Root:     Block (0)  Level (0)
>                    FastRoot: Block (0)  Level (0)
>
> <Special Section> -----
>  BTree Index Section:
>   Flags: 0x0008 (META)
>   Blocks: Previous (0)  Next (0)  Level (0)  CycleId (0)
>
>
> *** End of File Encountered. Last Block Read: 0 ***
>
> $ ls -l /srv/postgresql/data/base/3400014/27059918
> -rw------- 1 postgres postgres 8192 Jul  1 06:28 /srv/postgresql/data/base/3400014/27059918
>
>
>
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
>
> 31.08.2010 09:32
>
> To
> robert(dot)moucha(at)lmc(dot)eu
> cc
> Subject
> Re: [HACKERS] thousand unrelated data files in pg_default tablespace
>
>
>
>
> Zdar,
>
> preposilam ti report
>
> 2010/8/30 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> > Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> >> I found a PostgreSQL 8.3 server (Linux) used for large OLAP where the
> >> data directory is bloating. There are more than one hundred thousand
> >> files - 8KB or 0KB long. The filenames are not transformable to names
> >> via oid2name. Does somebody know about similar bug?
> >
> > 1. 8.3.what?
> >
> > 2. Any signs of distress in the postmaster log?  I'm wondering about
> > being unable to complete checkpoints, or repeated backend crashes that
> > might cause leakage of temp tables.
> >
> > 3. What's in the files --- do they appear to be tables, indexes, random
> > temp files from sorts/hashes, or what?  pg_filedump might help you here.
> >
>
> muzes se na ten pg_filedump podivat a projet to tim, myslim, ale ze se
> to bude muset od nekud stahnout a prelozit
>
> Pavel
>
>
> >                        regards, tom lane
> >
>