Re: Huge size of Data directory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Huge size of Data directory
Дата
Msg-id 2751.1137617640@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Huge size of Data directory  ("Anthony Presley" <anthony@resolution.com>)
Ответы Re: Huge size of Data directory  ("Anthony Presley" <anthony@resolution.com>)
Список pgsql-novice
"Anthony Presley" <anthony@resolution.com> writes:
> However, more surprising to me is that it has (over the past few years)
> become HUGE.  It's currently 606MB.  Almost all of this space is sitting
> in data/base/16556 and data/pg_xlog.

> The problem I have with this space ... is that I only have about 8MB of
> data stored in the database (according to pg_dump and pg_dumpall).

You need to read the documentation about routine vacuuming ...
http://www.postgresql.org/docs/8.1/static/maintenance.html

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Greg Lindstrom
Дата:
Сообщение: Swappng Filds
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Huge size of Data directory