Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6740319DE833 for ; Wed, 7 Mar 2012 10:35:21 -0400 (AST) Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5HxX-0002tk-Ef for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 14:35:20 +0000 Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 99A8BE00EC82; Wed, 7 Mar 2012 06:35:05 -0800 (PST) Message-ID: <4F577217.3080204@pinpointresearch.com> Date: Wed, 07 Mar 2012 06:35:03 -0800 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: Lukasz Brodziak CC: pgsql-admin@postgresql.org Subject: Re: pg_attribute file in PostgreSQL 9.0 References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/22 X-Sequence-Number: 39210 On 03/07/2012 05:14 AM, Lukasz Brodziak wrote: > Hello, > > I have a question regarding pg_attribute. In which file it is stored > because the relfilenode for it shows 0 and file 1249 isn't present in > the folder. > select pg_relation_filepath('pg_attribute'); From the docs, relfilenode is: "Name of the on-disk file of this relation; zero means this is a "mapped" relation whose disk file name is determined by low-level state" However the meaning "mapped relation" and "low-level state" are difficult to divine from the docs. Go with the function. Cheers, Steve