From: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Returning schema name with table name |
Date: | 2008-11-24 12:39:48 |
Message-ID: | 492AA094.6010304@proventis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
it shows all except toast entries. for included values see
http://www.postgresql.org/docs/8.3/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
function |pg_total_relation_size|(oid)
Andrus schrieb:
>> my standard query (adapted to 1mb size) is:
>
> Thank you very much.
> This query shows toast files in a cryptic way:
>
> db_owner pg_toast pg_toast_40552_index 1352 kB
>
> How to change it so that it shows also relation name whose data
> pg_toast_40552_index contains?
> It is not possible to determine from this query output which data is
> contained in pg_toast_40552_index file.
>
> Andrus.
>
--
Thomas Markus
====================================================
proventis GmbH | Zimmerstr. 79-81 | D-10117 Berlin |
Tel +49 (0)30 2936399-22 | Fax -50 | t(dot)markus(at)proventis(dot)net
-----------------------------------------------------------------
Geschäftsführer: Norman Frischmuth | Sitz: Berlin
Handelsregister: AG Berlin-Charlottenburg, HR 82917
-----------------------------------------------------------------
Blue Ant-webbasiertes Projektmanagement - aktuelle Termine 2008:
http://www.proventis.net/website/live/blueant/veranstaltungen.html
====================================================
Attachment | Content-Type | Size |
---|---|---|
t_markus.vcf | text/x-vcard | 255 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2008-11-24 12:42:39 | literal limits in 8.3 |
Previous Message | Andrus | 2008-11-24 11:53:11 | Re: Returning schema name with table name |