SEO

#1 (**permalink**) 04-10-2008, 07:25 AM

Hello, would anyone know the cript for disk space use (psql)? Please help.
Thank you
Trula

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

#2 (**permalink**) 04-10-2008, 07:25 AM

You can use combinations of
Database Object Size Functions to create the script.
Hope this will help
with regards

Ashish...

Trula Thomas <trulathomas@yahoo.com> wrote:
Hello, would anyone know the cript for disk space use (psql)? Please help.
Thank you
Trula
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.

---------------------------------
Check out what you're missing if you're not on Yahoo! Messenger

#3 (**permalink**) 04-10-2008, 07:26 AM

Try this:-

-- Query returns size of a database calculated from the no. 8k pages
allocated to tables
SELECT
-- *
sum( relpages*8/1024 ) as MB
FROM
pg_class
WHERE
-- relname != ''
-- relname = 'document'
relnamespace = '2200'

On 4/16/07, Trula Thomas <trulathomas@yahoo.com> wrote:
>
> Hello, would anyone know the cript for disk space use (psql)? Please help.
> Thank you
> Trula
>
> ------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc 2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Cript for DISK SPACE USE psql