Re: [PATCHES] Dbsize backend integration - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: [PATCHES] Dbsize backend integration
Date
Msg-id 42C463AC.2060603@commandprompt.com
Whole thread Raw
In response to Re: [PATCHES] Dbsize backend integration  (Dawid Kuroczko <qnex42@gmail.com>)
List pgsql-hackers
Dawid Kuroczko wrote:
> On 6/30/05, Dave Page <dpage@vale-housing.co.uk> wrote:
> 
>>>-----Original Message-----
>>>From: Bruce Momjian [mailto:pgman@candle.pha.pa.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/


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: WAL oddities (8.0.3)
Next
From: Tom Lane
Date:
Subject: Re: Occupied port warning