Gavin Sherry wrote:

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]

Reply via email to