Re: [PATCHES] Dbsize backend integration

Dawid Kuroczko wrote:
> On 6/30/05, Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
>
>>>-----Original Message-----
>>>From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
>>>Sent: 29 June 2005 12:46
>>>To: Dave Page
>>>Cc: PostgreSQL-patches; PostgreSQL-development
>>>Subject: Re: [PATCHES] Dbsize backend integration
>>>
>>>I have a new idea --- pg_storage_size().
>>
>>I'm not against that one, but I think Tom's point is vaild. I cannot
>>think of anything better at the moment though (maybe pg_component_size,
>>but that's equally random) :-(
>>
>>Anyone else? Please? Someone? Anyone? :-)

pg_df(text,text)

where the $1 would be the relation name and $2 would
be the type of output (human readable, bytes etc...)

J

>
>
> pg_diskspace_size()
> pg_diskusage_size()
> pg_media_used_size()
> pg_allocated_size()
> pg_diskspace_used()
>
> Regards,
> Dawid
>
> PS: Yep, they aren't good...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/