Skip site navigation (1) Skip section navigation (2)

Re: Table size on disk

From: "Cristina Surroca" <cris(at)dmcid(dot)net>
To: "Kris Kiger" <kris(at)musicrebellion(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Table size on disk
Date: 2003-05-20 19:30:19
Message-ID: 001401c31f06$42ab1900$fe35393e@cris (view raw or flat)
Thread:
Lists: pgsql-admin
select relname, relpages from pg_class;
relname is the table name.
relpages is number of pages of 8 K that needs the table to be stored.

(sorry for my English)

yours

Cris..
----- Original Message ----- 
From: "Kris Kiger" <kris(at)musicrebellion(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, May 20, 2003 4:58 PM
Subject: [ADMIN] Table size on disk


> Is there a good way to tell how much physical space a table takes on 
> disk?  Thanks
> 
> Kris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html


In response to

Responses

pgsql-admin by date

Next:From: kevinDate: 2003-05-20 20:57:58
Subject: Re: Grant Question
Previous:From: Shankar KDate: 2003-05-20 18:54:42
Subject: last analyzed date on tables/databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group