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, whole thread or download thread mbox)
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)


----- 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?

In response to


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-2017 The PostgreSQL Global Development Group