Re: [PATCHES] Tablespace patch review

[Andreas Pflug]

Gavin Sherry wrote:

Advertising







On Fri, 18 Jun 2004, Andreas Pflug wrote:
 

Gavin Sherry wrote:
   

On Fri, 18 Jun 2004, Bruce Momjian wrote:
[snip]

     

TODO.  You sound like a man who's expecting a
several-generations-polished facility when we only just committed
the first version today.  I do not feel a need to have any of these
features in 7.5 ...
         

I just need to know what to add to the TODO list, and so we can answer
people who are going to ask for this functionality.  Added to TODO:
        * Allow reporting of which objects are in which tablespaces
       

Do we need an information_schema.tablespaces view as well as an update to
information_schema.{tables|indexes|...} ?
     

I checked this to implement it, and found it being less then trivial
when *all* objects of a tablespace should be displayed, not just the
ones in the current database.
   

I don't think we should try and show all objects for a tablespace in
information_schema.
Agreed, information_schema is database specific. I was thinking about a 
pg_tablespace_contents(..) function anyway.

Being able to list all objects in a tablespace, including which databases
they are in, is clearly useful, however (eg: hunting down use of a give
tablespace that you want dropped). Sounds like a script in contrib (or the
main source tree?) to me.
 

You're suggesting the dblink way using a shell script. Imagine 20, 200, 
... databases. This would be a costly thing (and has to be  implemented 
differently in win32).
I'd like to see an implementation that enables gui interfaces to show 
objects that depend on a tablespace, so you'd need to be aware of a user 
clicking on "show what's in that tablespace" and he probably wouldn't 
expect to wait an extended period of time for all databases to be 
scanned, or impose a 200-connection load on the server.

IMHO checking objects in a tablespace is a routine administrative task, 
so it should be supported natively by the server without need of 
contribs. And for win user acceptance, a command line tool won't be 
sufficient either.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]