sys.#storage SEEMS to have what you want, but I haven't been able to figure out how to issue queries on any of the tables that start with '#'. sql>\d #storage CREATE TABLE "sys"."#storage" ( "schema" CHARACTER LARGE OBJECT, "table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "location" CHARACTER LARGE OBJECT, "count" BIGINT, "capacity" BIGINT, "width" INTEGER, "size" BIGINT, "hashsize" BIGINT ); I found this last week when trying to figure out the location of columns. On Tue, Jan 10, 2012 at 8:32 AM, Vassilis Papakonstantinou < papv@ics.forth.gr> wrote:
** What I mean is to get how much space is being used by each table in a database..
Vassilis
On 01/10/2012 02:08 PM, Vassilis Papakonstantinou wrote:
Hello,
Is there a way to get the disk space of a table?
Vassilis
------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/joinhttp://p.sf.net/sfu/intel-appdev _______________________________________________ MonetDB-users mailing listMonetDB-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users