Re: disk space - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: disk space
Date
Msg-id 200207100209.g6A29fo13384@candle.pha.pa.us
Whole thread Raw
In response to Re: disk space  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Bruce Momjian wrote:
> becks wrote:
> > hello.
> > how to check disk space usage for a single table?
>
> Look at relpages in pg_class for that table.  VACUUM the table first.

Actually, I wrote some stuff up for the 7.3 docs on this:

    http://developer.postgresql.org/docs/postgres/diskusage.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: disk space
Next
From: Bruce Momjian
Date:
Subject: Re: Authentication in batch processing