Re: thousand unrelated data files in pg_default tablespace - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: thousand unrelated data files in pg_default tablespace
Date
Msg-id AANLkTikJJ2ocTgOKtoCVuzpUEoWKdsmN4hP4UGLzk_RJ@mail.gmail.com
Whole thread Raw
In response to Re: thousand unrelated data files in pg_default tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: thousand unrelated data files in pg_default tablespace  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
hello

2010/8/31 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> there is a dump from 8KB files
>
> Well, those certainly look like tables/indexes not temp files.
> So we can rule out one theory.
>
> You're *certain* these aren't referenced from pg_class.relfilenode
> of any of the databases in the server?

I have a info, so these files are not in pg_class.relfilenode. More -
these files are three months old, and in this time was server two
times restarted.

Regards

Pavel Stehule

>                        regards, tom lane
>


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Synchronous replication - patch status inquiry
Next
From: Tatsuo Ishii
Date:
Subject: regclass without error?