--- Tom Lane <[EMAIL PROTECTED]> wrote: > Frank Way <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] "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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
