Skip site navigation (1) Skip section navigation (2)

Re: TODO item inquiry/claim

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Brent Verner <brent(at)rcfile(dot)org>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item inquiry/claim
Date: 2002-02-22 23:06:12
Message-ID: 200202222306.g1MN6Ce04399@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Brent Verner wrote:
> On 18 Nov 2001 at 18:17 (+0100), Peter Eisentraut wrote:
> | Brent Verner writes:
> | 
> | > * Add table name mapping for numeric file names
> | 
> | > It's been tested with 7.1 and 7.2bN and is basically a few c functions
> | > that allow (approximate) reports of disk usage (in Kb) per database,
> | > and  per relation (only on the current database, for now).
> | 
> | I've written on like that a while ago:
> | 
> | http://webmail.postgresql.org/~petere/dbsize.html
> | 
> | The tarball can be rolled into contrib -- now that I think of it I don't
> | know why I never did that.
> 
>   Can you put your code in contrib?  I've seen atleast a few other 
> users wanting to measure disk use.

Done.

> | Never imagined this would have anything to do with that TODO item, though.
> | I figured oid2name accomplished that.
> 
>   Yeah, but it address one inconvenience caused by the oid-named files.
> Even after reading through the thread[1], I'm not sure what the desired
> solution to the problem is.  There seem to be two reasons to know
> the filename->(db|rel) mapping.
> 
>   1) resource usage [solved]

Yes.

>   2) data recovery from db failure.
> 
>   Are there any other reasons an admin needs to know the actual
> filenames the system is using?  Please reply if you have any.
> 
>   I really have no idea what all would be involved in recovering a
> database (or a single relation, if possible), so I would appreciate
> suggestions on what needs to be done to address this issue WRT the
> filename->(db|rel) mappings.  There was not a concensus on what the
> proper solution would look like; some suggested maintaining symlinks,
> other suggested a separate file of mappings.  If someone would tell
> me what a reliable solution would be, I'll work at implementing it
> for inclusion in one of the 7.2.X maintenance releases.

I wish I knew the answer.  :-)

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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-02-22 23:29:18
Subject: Re: [Fwd: [PATCHES] Libpq support for precision and scale]
Previous:From: Bruce MomjianDate: 2002-02-22 22:51:54
Subject: Re: elog() proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group