Re: dbsize patch - Mailing list pgsql-patches

From Andreas Pflug
Subject Re: dbsize patch
Date
Msg-id 41FA208F.1070704@pse-consulting.de
Whole thread Raw
In response to Re: dbsize patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> Andreas Pflug <pgadmin@pse-consulting.de> writes:
>
>>Hm, these are all implementable as SQL functions, do we need these hard
>>coded too?
>
>
>>e.g.
>>create function aggregate_relation_size(oid) returns int8 as $CODE$
>>select sum(pg_relation_size(indexrelid)) from pg_index where indrelid=$1;
>>$CODE$ language 'SQL'
>
>
> Your suggestion would be more compelling if the example were correct ;-).
> Consider more than one index on the same table.

Hopefully SUM() will do the job.

Regards,
Andreas

pgsql-patches by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: Continue transactions after errors in psql
Next
From: Robert Treat
Date:
Subject: Re: Continue transactions after errors in psql