I would like to identify the objects which all of a sudden are frowing
at the high growth rate by using the filename (which I assune is the
OID). I have looked at the pg_catalog schema to see if I could see an
obvious way to do this, but to no avail. Furthermore, I hate to keep
bothering the ng with these types of questions - is there a reference
which lists the functions/views available in pg_catalog which can be
used for this type of check?
http://www.postgresql.org/docs/8.1/static/functions-admin.html
The functions listed in the link above will allow you to figure out
which of your tables are taking up the most hd space.
Sincerely,
Joshua D. Drake
TA,
Benjamin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
