Re: Table size on disk - Mailing list pgsql-admin

From Cristina Surroca
Subject Re: Table size on disk
Date
Msg-id 001401c31f06$42ab1900$fe35393e@cris
Whole thread Raw
In response to Re: Howto Setup a good PostgreSQL Server  ("Kuhn, Dylan K (4520500D)" <Dylan.Kuhn@navy.mil>)
Responses Re: Table size on disk
List 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@musicrebellion.com>
Cc: <pgsql-admin@postgresql.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


pgsql-admin by date:

Previous
From: Shankar K
Date:
Subject: last analyzed date on tables/databases
Next
From: Bob Smith
Date:
Subject: Changing NOT NULL condition on column