--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Frank Way <fgw_three(at)yahoo(dot)com> writes:
> > After finding the ctid in (block,tuple) format, how do you know
> > 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.....
"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!
In response to
pgsql-admin by date
|Next:||From: Jodi Kanter||Date: 2004-01-29 14:10:41|
|Subject: Re: [Fwd: binary tree query]|
|Previous:||From: Bruno Wolff III||Date: 2004-01-29 13:08:47|
|Subject: Re: Routine maintenance - vacuum, analyse and autovacuum|