Обсуждение: Documentation on disk usage

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

Documentation on disk usage

От
Bruce Momjian
Дата:
Since we just had the discussion about index size, I have written a
section for our administration manual that shows ways of finding the
disk usage for specific tables and databases:
http://candle.pha.pa.us/main/writings/pgsql/sgml/diskusage.html

I also updated README.oid2name to show a sample session that analyzes
disk usage.

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


Re: Documentation on disk usage

От
Peter Eisentraut
Дата:
It's much easier to use the routines in contrib/dbsize.

> Since we just had the discussion about index size, I have written a
> section for our administration manual that shows ways of finding the
> disk usage for specific tables and databases:
>
>     http://candle.pha.pa.us/main/writings/pgsql/sgml/diskusage.html
>
> I also updated README.oid2name to show a sample session that analyzes
> disk usage.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Documentation on disk usage

От
Bruce Momjian
Дата:
Peter Eisentraut wrote:
> It's much easier to use the routines in contrib/dbsize.

Done, though dbsize does not address indexes or TOAST tables.  I have
added documentation to SGML to show how to find these values.


> 
> > Since we just had the discussion about index size, I have written a
> > section for our administration manual that shows ways of finding the
> > disk usage for specific tables and databases:
> >
> >     http://candle.pha.pa.us/main/writings/pgsql/sgml/diskusage.html
> >
> > I also updated README.oid2name to show a sample session that analyzes
> > disk usage.
> 
> -- 
> Peter Eisentraut   peter_e@gmx.net
> 
> 

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