Re: Numeric file names - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Numeric file names
Date
Msg-id 200010282207.SAA21773@candle.pha.pa.us
Whole thread Raw
In response to Re: Numeric file names  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> Bruce Momjian writes:
> 
> > Now that we have numeric file names, I would like to have a command I
> > can run from psql that will dump a mapping of numeric file name to table
> > name, i.e.,
> > 
> >     121233    pg_proc
> >     143423    pg_index
> 
> select oid, relname from pg_class;

Oh, we went with oid-based file names.  OK.

> > With that feature, I can write scripts pgfile2name and pgname2file that
> > map file names to table names.  People can run standard Unix commands
> > and have meaningful display output:
> > 
> >     ls -l | pgfile2name
> 
> sed `psql -Aqt -d ${database} -c "select'-e s/' || oid || '/' || relname || '/g' from pg_class"`
> 
> 
> What I'd find useful is a program that you can occasionally run on a
> database directory that creates links from "name" to "oid".

Yes, that too.  You can then do ls -L on the symlinks to see the
underlying sizes.

My utilities are more generic.  Also, they will allow programs like
fstat/lsof to show meaningful output, though it may be tough to guess
the database from the fstat output.  lsof prints the full path, so that
is OK.  The script will guess the database from the path name.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Numeric file names
Next
From: Bruce Momjian
Date:
Subject: Re: Numeric file names