From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: "Orphaned" files after initdb |
Date: | 2013-04-01 19:24:06 |
Message-ID: | CABUevEzO=AA5nF0xepT+PrQnCcEtx=yijh=BdGVSNVgAx8SsQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Apr 1, 2013 at 9:09 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> Hi,
>
> On 2013-04-01 20:43:36 +0200, Magnus Hagander wrote:
>> Maybe my thinking is just missing something obvious here. But looking
>> at a fresh initdb, I'm seeing a number of files in the data directory
>> for this database that don't have corresponding entries in pg_class. I
>> looked for entries based on relfilenode in pg_class - am I missing
>> some other way we put files in there?
>>
>> I'm seeing the same on both head and 9.1 as an example, but different oids.
>>
>> I feel I'm either missing something obvious, or we have a problem
>> here? And somehow the first one seems more likely..
>>
>> The query I ran (yeah, i'm sure it can be written prettier, but this
>> was quick-n-dirty):
>>
>> with t as (
>> select * from pg_ls_dir('<datadir>/base/1') l(f)
>> where f not in (
>> select relfilenode::text from pg_class
>> union all select relfilenode::text || '_vm' from pg_class
>> union all select relfilenode::text || '_fsm' from pg_class)
>> )
>> select f,
>> size,
>> modification
>> from t, pg_stat_file('<datadir>/base/1/' || f)
>> order by 1;
>
> You're missing nailed tables which don't have a valid relfilenode (but
> InvalidOid/0) in pg_class.relfilenode. You need to query the refilenode like
> SELECT pg_relation_filenode(pg_class.oid) FROM pg_class.
Ha. Of course. I knew it was me getting it wrong.
You'd get extra happy if only you knew how many pretty senior pg folks
i pestered about that one on irc before posting here :D
Thanks!
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-04-01 19:24:15 | plpgsql_check_function - plan for 9.4 |
Previous Message | Andres Freund | 2013-04-01 19:09:16 | Re: "Orphaned" files after initdb |