disk space

Поиск
Список
Период
Сортировка
Искать

disk space

От:
becks@ultraviolence.org (becks)
Дата:
hello.
how to check disk space usage for a single table?

Re: disk space

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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.

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

Re: disk space

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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
FAQ