Tom Lane wrote:
> Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:
>>Hm, these are all implementable as SQL functions, do we need these hard
>>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.
In response to
pgsql-patches by date
|Next:||From: Stephen Frost||Date: 2005-01-28 13:48:37|
|Subject: Re: [PATCHES] Merge pg_shadow && pg_group -- UNTESTED|
|Previous:||From: Michael Paesold||Date: 2005-01-28 10:33:29|
|Subject: Re: Continue transactions after errors in psql|