Re: Tablespace patch review - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Tablespace patch review
Date
Msg-id 200406182331.i5INVVv16564@candle.pha.pa.us
Whole thread Raw
In response to Re: Tablespace patch review  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> Gavin Sherry <swm@linuxworld.com.au> writes:
> > On Fri, 18 Jun 2004, Bruce Momjian wrote:
> >> * Allow reporting of which objects are in which tablespaces

This would have to be an external tool that connects to each database.

>
> > Do we need an information_schema.tablespaces view as well as an update to
> > information_schema.{tables|indexes|...} ?
>
> That would depend on your theology about whether implementation-specific
> additions to information_schema are a good idea or not.  I'd lean
> against doing this myself.  ISTM the entire point of information_schema
> is to be standard, and additions are, well, not.  Worse, they might
> conflict with future extensions to the standard.
>
> I don't actually see a way *inside the database* to implement Bruce's
> TODO item; there's no way for a backend to look at the catalogs of other
> databases.  We could look to see which databases had nonempty
> subdirectories of a tablespace, and report those databases by name, but
> explaining exactly what's inside those subdirectories is a lot harder.

The best we could do here is to just report the database name and the
relfilenode.


>
> It might be better to think about supporting this need with oid2name
> or some similar client-level tool.  It's easy to see how oid2name
> might be extended to produce an output like
>
>     Tablespace t1
>         Database d1
>             Table x
>             Table y
>         Database d2
>     etc etc

Yep, that's what I was thinking --- an external tool.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Nested transactions
Next
From: Andreas Pflug
Date:
Subject: Re: Tablespace patch review