X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2B67ED1CCD4 for ; Thu, 29 Jan 2004 14:09:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 39853-09 for ; Thu, 29 Jan 2004 10:09:35 -0400 (AST) Received: from web11604.mail.yahoo.com (web11604.mail.yahoo.com [216.136.172.56]) by svr1.postgresql.org (Postfix) with SMTP id DF7DCD1CACD for ; Thu, 29 Jan 2004 10:09:25 -0400 (AST) Message-ID: <20040129140934.37876.qmail@web11604.mail.yahoo.com> Received: from [206.105.19.34] by web11604.mail.yahoo.com via HTTP; Thu, 29 Jan 2004 06:09:34 PST Date: Thu, 29 Jan 2004 06:09:34 -0800 (PST) From: Frank Way Subject: Re: How to determine which file contains which block To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <7274.1075329916@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/267 X-Sequence-Number: 12130 --- Tom Lane wrote: > Frank Way writes: > > After finding the ctid in (block,tuple) format, how do you know > which > > file in all the subdirectories under /usr/local/pgsql/data/base > > contains that block? > > The subdirectories are named after the OIDs of their databases > (pg_database.oid column). Individual files are named after the > relfilenodes of their tables/indexes (pg_class.relfilenode). > Note also that tables exceeding 1GB will be broken into gigabyte-size > segments named nnn, nnn.1, nnn.2, etc; if you are dealing with one > of these then you need to determine which segment to use from the > block number. > > regards, tom lane > Thanks Tom, your answer is MUCH appreciated..... frank ===== Frank Way E-Mail: fgw_three@yahoo.com "Place guards on all the roads and keep the troops from running to the rear..." MG John Buford, 1863 __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/